views:

19

answers:

0

I am using System.data.Oracleclinet.OracleCommand.ExecuteNonQuery() to run my stored procedure.

I observer the following strange thing.

When execution runs throught COmmand.executeNonQuery it is giving 1 as the return value 1. But the stored procedure is not run and the output variable shows empty value({}).

But if I run the same(command.executenonquery()) in QUICK VIEW window the stored procedure is running fine and I am able to see the output variable value.

Any thoughts of the cause?

Thank you, Praveen