1

I am working with Oracle in .net using the ODP.NET. I was wondering how I get the variables from an out variable when calling a stored procedure.

What I have currently is...

using(IDataReader reader = defaultDB.ExecuteReader("CalledStoredProc", new object[]{"InputVar", "OutPutVar"}))
{
    //Display the rows for the reader.
    DisplayRowVals(reader);
}

If you guys have any suggestions I would definitely appreciate it.
Thanks, Derek

SoftwareSavant
  • 9,467
  • 27
  • 121
  • 195

2 Answers2

2

You actually call the stored procedure with an additional parameter of type Cursor with direction of Output.

Your stored procedure populates the cursor, and then you iterate over the (now modified) parameter in your DAL.

Jonathan
  • 1,866
  • 12
  • 10
1
DbCommand command = db.GetStoredProcCommand( sprocName );
command.Parameters.Add( new OracleParameter( "out_value", OracleDbType.Int32, ParameterDirection.Output ) );

db.ExecuteNonQuery( command );
Jordan Parmer
  • 36,042
  • 30
  • 97
  • 119