在行: 2 上开始执行命令时出错 -declare cursor cdept is select dno,dname from dep; pdno dep.dno%type; pdname dep.dname%type; cursor cgrade(coursename varchar2,depno number) is select grade from sc where cno=(select cno from course where cname=coursename) and sno in (select sno from student where dno=depno); pgrade sc.grade%type; count1 number; count2 number; count3 number; avggrade number; pcourseName VARCHAR2(3):='大学物理';begin open cdept; loop fetch cdept into pdno,pdname; exit when cdept%notfound; count1:=0; count2:=0; count3:=0; select avg(grade) into avggrade from sc where cno=(select cno from course where cname=pcourseName) and sno in (select sno from student where dno=pdno); open cgrade(pcourseName,pdno); loop fetch cgrade into pgrade; exit when cgrade%notfound; if pgrade <60 then count1:= count1+1; elsif pgrade >60 and pgrade <85 then count2:=count2+1; else count3:=count3+1; end if; end loop; close cgrade; insert into msg1 values (pcourseName,pdname,count1,count2,count3,avggrade); end loop; close cdept; commit; DBMS_OUTPUT.PUT_LINE('统计完成');end;错误报告 -ORA-06502: PL/SQL: 数字或值错误 : 字符串缓冲区太小ORA-06512: 在 line 1306502. 00000 - "PL/SQL: numeric or value error%s"*Cause: An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if an attempt is made to assign the value NULL to a variable declared NOT NULL, or if an attempt is made to assign an integer larger than 99 to a variable declared NUMBER(2).*Action: Change the data, how it is manipulated, or how it is declared so that values do not violate constraints.在行: 2 上开始执行命令时出错 -declare cursor cdept is select dno,dname from dep; pdno dep.dno%type; pdname dep.dname%type; cursor cgrade(coursename varchar2,depno number) is select grade from sc where cno=(select cno from course where cname=coursename) and sno in (select sno from student where dno=depno); pgrade sc.grade%type; count1 number; count2 number; count3 number; avggrade number; pcourseName VARCHAR2:='大学物理';begin open cdept; loop fetch cdept into pdno,pdname; exit when cdept%notfound; count1:=0; count2:=0; count3:=0; select avg(grade) into avggrade from sc where cno=(select cno from course where cname=pcourseName) and sno in (select sno from student where dno=pdno); open cgrade(pcourseName,pdno); loop fetch cgrade into pgrade; exit when cgrade%notfound; if pgrade <60 then count1:= count1+1; elsif pgrade >60 and pgrade <85 then count2:=count2+1; else count3:=count3+1; end if; end loop; close cgrade; insert into msg1 values (pcourseName,pdname,count1,count2,count3,avggrade); end loop; close cdept; commit; DBMS_OUTPUT.PUT_LINE('统计完成');end;错误报告 -ORA-06550: 第 13 行, 第 21 列: PLS-00215: 字符串长度限制在范围 (1...32767)06550. 00000 - "line %s, column %s:\n%s"*Cause: Usually a PL/SQL compilation error.*Action:在行: 2 上开始执行命令时出错 -declare cursor cdept is select dno,dname from dep; pdno dep.dno%type; pdname dep.dname%type; cursor cgrade(coursename varchar2,depno number) is select grade from sc where cno=(select cno from course where cname=coursename) and sno in (select sno from student where dno=depno); pgrade sc.grade%type; count1 number; count2 number; count3 number; avggrade number; pcourseName VARCHAR2:='大学物理';begin open cdept; loop fetch cdept into pdno,pdname; exit when cdept%notfound; count1:=0; count2:=0; count3:=0; select avg(grade) into avggrade from sc where cno=(select cno from course where cname=pcourseName) and sno in (select sno from student where dno=pdno); open cgrade(pcourseName,pdno); loop fetch cgrade into pgrade; exit when cgrade%notfound; if pgrade <60 then count1:= count1+1; elsif pgrade >60 and pgrade <85 then count2:=count2+1; else count3:=count3+1; end if; end loop; close cgrade; insert into msg1 values (pcourseName,pdname,count1,count2,count3,avggrade(20)); end loop; close cdept; commit; DBMS_OUTPUT.PUT_LINE('统计完成');end;错误报告 -ORA-06550: 第 13 行, 第 21 列: PLS-00215: 字符串长度限制在范围 (1...32767)ORA-06550: 第 32 行, 第 78 列: PLS-00222: 在此范围中不存在名为 'AVGGRADE' 的函数ORA-06550: 第 32 行, 第 78 列: PL/SQL: ORA-00904: : 标识符无效ORA-06550: 第 32 行, 第 13 列: PL/SQL: SQL Statement ignored06550. 00000 - "line %s, column %s:\n%s"*Cause: Usually a PL/SQL compilation error.*Action:在行: 2 上开始执行命令时出错 -declare cursor cdept is select dno,dname from dep; pdno dep.dno%type; pdname dep.dname%type; cursor cgrade(coursename varchar2,depno number) is select grade from sc where cno=(select cno from course where cname=coursename) and sno in (select sno from student where dno=depno); pgrade sc.grade%type; count1 number; count2 number; count3 number; avggrade number; pcourseName VARCHAR2:='大学物理';begin open cdept; loop fetch cdept into pdno,pdname; exit when cdept%notfound; count1:=0; count2:=0; count3:=0; select avg(grade) into avggrade from sc where cno=(select cno from course where cname=pcourseName) and sno in (select sno from student where dno=pdno); open cgrade(pcourseName,pdno); loop fetch cgrade into pgrade; exit when cgrade%notfound; if pgrade <60 then count1:= count1+1; elsif pgrade >60 and pgrade <85 then count2:=count2+1; else count3:=count3+1; end if; end loop; close cgrade; insert into msg1 values (pcourseName,pdname,count1,count2,count3,avggrade); end loop; close cdept; commit; DBMS_OUTPUT.PUT_LINE('统计完成');end;错误报告 -ORA-06550: 第 13 行, 第 21 列: PLS-00215: 字符串长度限制在范围 (1...32767)06550. 00000 - "line %s, column %s:\n%s"*Cause: Usually a PL/SQL compilation error.*Action:在行: 14 上开始执行命令时出错 -pcourseName错误报告 -未知的命令在行: 2 上开始执行命令时出错 -declare cursor cdept is select dno,dname from dep; pdno dep.dno%type; pdname dep.dname%type; cursor cgrade(coursename varchar2,depno number) is select grade from sc where cno=(select cno from course where cname=coursename) and sno in (select sno from student where dno=depno); pgrade sc.grade%type; count1 number; count2 number; count3 number; avggrade number; pcourseName varchar2 := '大学物理';begin open cdept; loop fetch cdept into pdno,pdname; exit when cdept%notfound; count1:=0; count2:=0; count3:=0; select avg(grade) into avggrade from sc where cno=(select cno from course where cname=pcourseName) and sno in (select sno from student where dno=pdno); open cgrade(pcourseName,pdno); loop fetch cgrade into pgrade; exit when cgrade%notfound; if pgrade <60 then count1:= count1+1; elsif pgrade >60 and pgrade <85 then count2:=count2+1; else count3:=count3+1; end if; end loop; close cgrade; insert into msg1 values (pcourseName,pdname,count1,count2,count3,avggrade); end loop; close cdept; commit; DBMS_OUTPUT.PUT_LINE('统计完成');end;错误报告 -ORA-06550: 第 13 行, 第 21 列: PLS-00215: 字符串长度限制在范围 (1...32767)06550. 00000 - "line %s, column %s:\n%s"*Cause: Usually a PL/SQL compilation error.*Action:
- 2 回答
- 0 关注
- 1116 浏览
添加回答
举报
0/150
提交
取消