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;
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;
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;