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
Receive Cursor Parameter
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
You can fill DataSet from any OracleCursor object as described below
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();
Code: Select all
DataSet ds = new DataSet();
cmd.ExecuteNonQuery();
oracleDataAdapter1.Fill(ds, ((OracleCursor)cmd.Parameters["pcur"].OracleValue));