set serveroutput on
declare
type stu_record_type is record
(
sno varchar2(10),
sname varchar2(10),
ssex varchar2(10),
saddress varchar2(50),
sstudy_grade varchar2(10),
sactivity_grade varchar2(10)
);
stu_rec stu_record_type;
proceducre PrintStuRecord(sturec stu_record_type)
as
begin
DBMS_OUTPUT.PUT_LINE('学号:'||sturec.sno);
DBMS_OUTPUT.PUT_LINE('姓名:'||sturec.sname);
DBMS_OUTPUT.PUT_LINE('性别:'||sturec.ssex);
DBMS_OUTPUT.PUT_LINE('籍贯:'||sturec.saddress);
DBMS_OUTPUT.PUT_LINE('学习成绩:'||sturec.sstudy_grade);
DBMS_OUTPUT.PUT_LINE('活动成绩:'||sturec.sactivity_grade);
end PrintStuRecord;
begin
stu_rec.sno:='001';
stu_rec.sname:='jack';
stu_rec.ssex:='male';
stu_rec.saddress:='湖南';
stu_rec.sstudy_grade:='80';
stu_rec.sactivity_grade:='80';
PrintStuRecord(stu_rec);
end;
/
在这个块内过程创建的过程中报错第12行,提示:
出现符号'stu_record_type'在需要下列之一时:
XXXXXXX
请问怎么解决?