在行: 2 上開(kāi)始執(zhí)行命令時(shí)出錯(cuò) -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):='大學(xué)物理';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('統(tǒng)計(jì)完成');end;錯(cuò)誤報(bào)告 -ORA-06502: PL/SQL: 數(shù)字或值錯(cuò)誤 :? 字符串緩沖區(qū)太小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 上開(kāi)始執(zhí)行命令時(shí)出錯(cuò) -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:='大學(xué)物理';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('統(tǒng)計(jì)完成');end;錯(cuò)誤報(bào)告 -ORA-06550: 第 13 行, 第 21 列:?PLS-00215: 字符串長(zhǎng)度限制在范圍 (1...32767)06550. 00000 -? "line %s, column %s:\n%s"*Cause:? ? Usually a PL/SQL compilation error.*Action:在行: 2 上開(kāi)始執(zhí)行命令時(shí)出錯(cuò) -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:='大學(xué)物理';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('統(tǒng)計(jì)完成');end;錯(cuò)誤報(bào)告 -ORA-06550: 第 13 行, 第 21 列:?PLS-00215: 字符串長(zhǎng)度限制在范圍 (1...32767)ORA-06550: 第 32 行, 第 78 列:?PLS-00222: 在此范圍中不存在名為 'AVGGRADE' 的函數(shù)ORA-06550: 第 32 行, 第 78 列:?PL/SQL: ORA-00904: : 標(biāo)識(shí)符無(wú)效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 上開(kāi)始執(zhí)行命令時(shí)出錯(cuò) -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:='大學(xué)物理';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('統(tǒng)計(jì)完成');end;錯(cuò)誤報(bào)告 -ORA-06550: 第 13 行, 第 21 列:?PLS-00215: 字符串長(zhǎng)度限制在范圍 (1...32767)06550. 00000 -? "line %s, column %s:\n%s"*Cause:? ? Usually a PL/SQL compilation error.*Action:在行: 14 上開(kāi)始執(zhí)行命令時(shí)出錯(cuò) -pcourseName錯(cuò)誤報(bào)告 -未知的命令在行: 2 上開(kāi)始執(zhí)行命令時(shí)出錯(cuò) -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 := '大學(xué)物理';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('統(tǒng)計(jì)完成');end;錯(cuò)誤報(bào)告 -ORA-06550: 第 13 行, 第 21 列:?PLS-00215: 字符串長(zhǎng)度限制在范圍 (1...32767)06550. 00000 -? "line %s, column %s:\n%s"*Cause:? ? Usually a PL/SQL compilation error.*Action: