Unable to cast object of type 'Oracle.DataAccess.Types.OracleRefCursor' to type 'Oracle.DataAccess.Client.OracleDataReader'. RSS

• • Reply
  

  duttasandip4...

  Member

  2 Points

  3 Posts

  Unable to cast object of type 'Oracle.DataAccess.Types.OracleRefCursor' to type 'Oracle.DataAcces...

  Mar 29, 2012 05:53 AM|LINK

  I am getting following exception

  "Unable to cast object of type 'Oracle.DataAccess.Types.OracleRefCursor' to type 'Oracle.DataAccess.Client.OracleDataReader'."

  I am using following Code:

  protected void btnTest2_Click(object sender, EventArgs e)
      {
          OracleCommand oraCommand = null;
          new DataAccess().ReturnSPResult("hms_general.TestProc",out oraCommand);
          
          OracleDataReader dr = (OracleDataReader)oraCommand.Parameters["ScheduleRecordset"].Value;
      }

  Bold text getting error;

  public void ReturnSPResult(string spName,out OracleCommand oraCommand)
      {        
          string connectionString = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
          
          try
          {
              OracleConnection conn = new OracleConnection(connectionString);
              conn.Open();
              oraCommand = conn.CreateCommand();
              oraCommand.CommandType = CommandType.StoredProcedure;
              oraCommand.Connection = conn;
              oraCommand.CommandText = spName;
  
              oraCommand.Parameters.Add("ScheduleRecordset", Oracle.DataAccess.Client.OracleDbType.RefCursor, ParameterDirection.Output);
              oraCommand.ExecuteNonQuery();
          }
          catch (OracleException ex)
          {
              throw ex;
          }
          catch (Exception ex)
          {
              throw ex;
          }
      }

  Please help me.

  Thanks in advance.