How do I get Oracle output variable data in .net

Question

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

Jonathan · Accepted Answer · 2011-06-14 20:57:01Z

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.

answered Jun 14, 2011 at 20:57

Jonathan

1,89212 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jordan Parmer · Accepted Answer · 2011-06-14 21:21:01Z

1

DbCommand command = db.GetStoredProcCommand( sprocName );
command.Parameters.Add( new OracleParameter( "out_value", OracleDbType.Int32, ParameterDirection.Output ) );

db.ExecuteNonQuery( command );

answered Jun 14, 2011 at 21:21

Jordan Parmer

37.4k30 gold badges100 silver badges120 bronze badges

Collectives™ on Stack Overflow

How do I get Oracle output variable data in .net

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related