oracle PLS-00103: 出现符号 "MRID1"在需要下列之一时:language
create or replace package stupkg ----stupkg是包的名称
is
PROCEDURE out_emr(MRIDs IN VARCHAR,audit_cursor out mycursor)
IS
BEGIN
OPEN audit_cursor for
SELECT mainmr.MRID,
mainmr.papernum,
inpatient.outdate,
inpatient.admiss_times,
inpatient.MDESCRIPT,
inpatient.MHISDESCRIPT,
inpatient.CHECKUP,
inpatient.CHECKASS,
inpatient.COURSEREC,
alldiagnoserecord.DIAGNOSECONTENT,
alldiagnoserecord.DIAGNOSERANGE
FROM mainmr, inpatient, alldiagnoserecord
WHERE mainmr.MRID = inpatient.MRID
AND inpatient.MRID = alldiagnoserecord.sickid
AND mainmr.MRID = MRIDs
AND (diagnosecontent = '妊娠糖尿病' OR diagnosecontent = '2型糖尿病' OR
diagnosecontent = '1型糖尿病' OR diagnosecontent = '特殊类型糖尿病' OR
diagnosecontent = '糖尿病');
END out_emr;
end stupkg;
Compilation errors for PACKAGE SZEMR.STUPKG
Error: PLS-00103: 出现符号 "BEGIN"在需要下列之一时:
language
Line: 47
Text: BEGIN
Error: PLS-00103: 出现符号 "STUPKG"在需要下列之一时:
;
Line: 142
Text: end stupkg;