create or replace procedure GetSettlementParameters(Billno in varchar2,RETURNTABLE out sys_refcursor,RETURNTABLEone out sys_refcursor)
as
begin
open RETURNTABLE for select * from ParameterSettings where ID=Billno;
open RETURNTABLEone for select ORGCODE from ParameterSettings where ID=Billno;
end;
declare
table_out sys_refcursor;
table_outnn sys_refcursor;
begin
GetSettlementParameters('1',RETURNTABLE=>table_out,RETURNTABLEone=>table_outnn);
end;
这样调用啥也没有 只是匿名快已完成