I have a stored procedure like this
- PROCEDURE PRC_ABCD_GETALL (resultset_out OUT TYPES.cursorType)
- AS
- BEGIN
- OPEN
- resultset_out FOR SELECT * FROM ABCD;
- END PRC_ABCD_GETALL;
And my C# code is
- using (OracleConnection conn = new OracleConnection(cnn))
- {
- conn.Open();
- OracleCommand cmd = new OracleCommand();
- cmd.Connection = conn;
- cmd.CommandText = "PRC_ABCD_GETALL";
- cmd.CommandType = CommandType.StoredProcedure;
- cmd.Parameters.Add("resultset_out", OracleType.Cursor, ParameterDirection.Output);
- OracleDataReader rdr = cmd.ExecuteReader();
- while (rdr.Read())
- {
- result.Add(Construct(rdr));
- }
- }
but I'm getting error 'OracleDbType' does not contain a definition for 'Cursor' in
OracleType.Cursor. Any solution for this??