StoredProcedure with IN ref cursor

[Kurt_Jegge]

Hello

Is there any way to use a stored procedure with an IN ref cursor sth. like:

sample

procedure set_steuerhist( c1_in in sys_refcursor )
is
myRecord steuer_hist%ROWTYPE;
begin
FETCH c1_in INTO myRecord;
insert into steuer_hist
(tkey,
datum,
...
erst_dat
)
values
(myRecord.tkey,
myRecord.datum,
...
myRecord.erst_dat
);
commit;
end set_steuerhist;

thanks Kurt

[Shalex]

There is no such possibility. We don't support this functionality, because ref cursor is bound to the connection.