get out parameter from oracle stored procedure

[raymond chiu]

Dear all,

I have one stored procedure which has one (in out) parameter.
How can I get the out parameter in .net development if I am using
oracleselectcommand1.executenonquery() with assigning in parameters.

Thansk,

Raymond Chiu

 

[Tushar Agarwal]

Dear all,

I have one stored procedure which has one (in out) parameter.
How can I get the out parameter in .net development if I am using
oracleselectcommand1.executenonquery() with assigning in parameters.

Thansk,

Raymond Chiu

Hi Raymond,
You should first add OleDbParameter object to your Command object and
then acees it(after executing the command ) using Parameters ReturnValue.