StoredProcedure with IN ref cursor

StoredProcedure with IN ref cursor

Postby Kurt_Jegge » Mon 09 Nov 2009 19:39

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
Kurt_Jegge
 
Posts: 21
Joined: Wed 09 Sep 2009 10:38

Postby Shalex » Tue 10 Nov 2009 11:14

There is no such possibility. We don't support this functionality, because ref cursor is bound to the connection.
Shalex
Devart Team
 
Posts: 7773
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle