procedure:
CREATE OR REPLACE procedure temp1 (name in varchar2,flag out number)
as
begin
flag:=1;
end ;
/
function:
CREATE OR REPLACE function temp (name in varchar2,flag out number)
return integer as
begin
flag:=1;
return 5;
end ;
/
调用procedure
declare
v_flag number;
begin
temp1('xxx',v_flag);
dbms_output.put_line(v_flag);
end;
调用function
declare
v_flag number;
retval number;
begin
retval :=temp('xxx',v_flag);
dbms_output.put_line(retval);
dbms_output.put_line(v_flag);
end;