当前位置: 代码迷 >> Oracle开发 >> 求急调试存储过程时,报ora-06550 PLS-00103
  详细解决方案

求急调试存储过程时,报ora-06550 PLS-00103

热度:158   发布时间:2016-04-24 07:53:05.0
求急!调试存储过程时,报ora-06550 PLS-00103
create   or   replace   procedure   P_grade(abc   varchar2)
    as
    gradeid   varchar2(10);
 
    begin
    select   ptgradeid   INTO   gradeid   FROM   B_PILOTTECHGRADE   where   ptgradeid   =   abc;
    dbms_output.put_line(gradeid);
    end   P_gradebe;
    /
   
    begin
      exec   P_grade( 'M ');
      end;

------解决方案--------------------
create table B_PILOTTECHGRADE (ptgradeid varchar2(100) );
insert into B_PILOTTECHGRADE values( 'aa ');

create or replace procedure P_grade(abc in varchar2)
as
gradeid varchar2(10);

begin
select ptgradeid INTO gradeid FROM B_PILOTTECHGRADE where ptgradeid = abc;
dbms_output.put_line(gradeid);
end P_grade;

declare
begin
p_grade( 'aa ' );
end;
  相关解决方案