创建存储过程:

create or replace procedure test (

p1 in out number,p2 in number,r1 out number,r2 out number) as

begin

r1 := p1 + p2;

r2 := p1 - p2;

p1 := 888;

end test;

执行:

declare

p1 number(3) :=10;

begin

test(p1,p1,p1,p1);

dbms_output.put_line('a + b = ' || p1);

end;