Passing data as ref cursor to Oracle stored Procedure

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a problem in passing data (30 input fields from form) to Oracle
Stored Procedure.My stored Procedure accepts only Ref Cusor.

Is there any other method to pass data between stored procedure in oracle.
Please suggest me.
Thank You

Jaiganesh.R
 
¤ Hi,
¤
¤ I have a problem in passing data (30 input fields from form) to Oracle
¤ Stored Procedure.My stored Procedure accepts only Ref Cusor.
¤
¤ Is there any other method to pass data between stored procedure in oracle.
¤ Please suggest me.

Unfortunately there is no support for ref_cursors as an input parameter, only as output parameters.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
A ref cursor implies that you have an active connection to an Oracle
select statement that is feeding you a row collection.

You should probably code a new proc that can create this, and call the
other proc.

If you don't want to put these 30 values in the DB it might be possible
to use a PL/SQL in-memory table, but I'm not sure if you can get a ref
cursor to an in-memory table. If anyone knows how to do this, please
post a message for us.

Eric
 
Back
Top