By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,317 Members | 2,412 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,317 IT Pros & Developers. It's quick & easy.

Passing IN ref cursor to Oracle 9.2 using EnterpriseLibrary

P: n/a
Can anyone offer pointers to articles/examples of passing a Ref Cursor
***IN*** to an Oracle stored procedure. I find tons of examples for getting a
ref cursor OUT of a stored procedure. I'm using the
Microsoft.Practices.EnterpriseLibrary.Data.Databas eFactory, NOT the ODT.NET
library (please don't ask why).

Thanks,
Randy
Oct 30 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Oct 30, 11:58 am, randy1200 <randy1...@discussions.microsoft.com>
wrote:
Can anyone offer pointers to articles/examples of passing a Ref Cursor
***IN*** to an Oracle stored procedure. I find tons of examples for getting a
ref cursor OUT of a stored procedure. I'm using the
Microsoft.Practices.EnterpriseLibrary.Data.Databas eFactory, NOT the ODT.NET
library (please don't ask why).

Thanks,
Randy
At least in .net1.1, it looks like ref cursor input parameters are not
supported. The excerpt from the docs are below. I don't know if
ODP.NET supports ref cursor input parameters but I believe it supports
array binding. An alternative (not pretty) approach is to break your
input up and push it to the database as very long batches.

"To execute a stored procedure that returns REF CURSOR data types, you
must define the parameters in the OracleParameterCollection with an
OracleType of Cursor and a Direction of Output. The data provider
supports binding REF CURSOR data types as output parameters only. The
provider does not support REF CURSOR data types as input parameters."

Oct 30 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.