ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to convert number out parameter into .net int type

499478Sep 9 2006 — edited Sep 10 2006

when i try to cast the OracleParamter to int in C#, it raises an exception:
OracleParameter outparam=cmd.Parameters.Add(":DOCID", OracleDbType.Int32, ParameterDirection.Output);
.........
.........
retval = Convert.ToInt32(outparam.Value);
this raises an exception
"Unable to cast object of type 'Oracle.DataAccess.Types.OracleDecimal' to type 'System.IConvertible'."

please show a code snippet to retrieve a integer out parameter from stored procedure.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 8 2006

Added on Sep 9 2006

#odp-net

1 comment

1,679 views