oracle里存储过程怎么调用存储过程,有out返回参数procedure1 调用procedure2(p_parma1 in number, p_parma2 out varchar2)
在procedure1 中怎么调用?
execute immediate call procedure2(: ) using in out param1,param2;
网上也搜不出来?
在procedure1 中怎么调用?
execute immediate call procedure2(: ) using in out param1,param2;
网上也搜不出来?
is
v_1 number := 0;
v_2 varchar2 := null;
begin
procedure2(v_1,v_2);
exception
when others then
...
end procedure;
有out返回参数 2个以上的out返回参数