Receive Cursor Parameter

[maher]

I have a stored procedure that returns a "cursor" parameter. What do I need to do on C# side to retrieve this parameter.

Thank You in Advance
Maher

[Paul]

You can use OracleCommand with stored procedure call in conjunction with OracleDataAdapter component and fill any DataSet as usual.
You can receive OracleCursor value from executed OracleCommand and receive OracleDataReader as described below

Code: Select all

OracleParameter p;
...
OracleDataReader r = ((OracleCursor)p.OracleValue).GetDataReader();

You can fill DataSet from any OracleCursor object as described below

Code: Select all

          DataSet ds = new DataSet();
          cmd.ExecuteNonQuery();
          oracleDataAdapter1.Fill(ds, ((OracleCursor)cmd.Parameters["pcur"].OracleValue));