Passing IN ref cursor to Oracle 9.2 using EnterpriseLibrary

[Guest]

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.DatabaseFactory, NOT the ODT.NET
library (please don't ask why).

Thanks,
Randy

 

[Arnshea]

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.DatabaseFactory, 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."