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