Passing data as ref cursor to Oracle stored Procedure

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
 
P

Paul Clement

¤ 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)
 
E

Eric

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EnterpriseLibrary. Return Recordset from oracle stored procedure 2
Oracle stored procedure with table as input parameter? 1
ODP.NET Ref Cursor Input to oracle Stored Procedure 2
DAAB with Oracle ref cursors 2
Passing IN ref cursor to Oracle 9.2 using EnterpriseLibrary 1
Returning CURSORS from ORACLE STORED FUNCTIONS 4
Stored procedure name in config file? 1
DbProviderFactory, Oracle and a ref cursor 3

Top