Hello Everyone,
I can successfully insert and update the oracle database by calling a oracles stored proc from my .net code. This oracle stored proc is returning some value. I cannot see that value in my .net code
Below is my .net code
OracleParameter mbrid = new OracleParameter("RET_MBRID", OracleType.Number);
mbrid.Direction = ParameterDirection.Output;
OracleDataReader reader;
reader = command.ExecuteReader();
while (reader.Read())
{
memberId = (string)reader[";RET_MBRID"];
}
I tested the oracle stored proc in sqlPlus and it is returning me value, but when i go to .net code, i cannot see the value of memberId. Am I doing something wrong here. Although my insert and update are working fine.
Insert and update statements are defined in the same stored proc.
I spent lot of time on this, but still cannot figure out why am I not getting the return value from oracle stored proc. I cannot even go inside the while(Reader.red()) statement
Any help will be grealty appreciated.
---------------------------------
Shape Yahoo! in your own image. Join our Network Research Panel today!
[Non-text portions of this message have been removed]
.
