Hi
I was struck up with big problem of executing a oracle stored procedure in C#.
Inputs 1:I am having 1 oracle stored procedure eg. myProc() and this procedure takes 1 INOUT parameter. of type stirng/varchar problem description: I am not able to execute this procedure through my C# code.
for more information, below is the C# code that i am using......
- OracleConnection con = new OracleConnection(StrConnectionString);
-
con.Open();
-
OracleCommand cmd = new OracleCommand("sapncdb.encrypt_field", con);
-
cmd.CommandType = CommandType.StoredProcedure;
-
OracleParameter inval = new OracleParameter("inval", OracleType.VarChar);
-
inval.Direction = ParameterDirection.InputOutput;
-
inval.Value = "13-4186423 ";
-
cmd.Parameters.Add(inval);
-
cmd.ExecuteNonQuery();
-
Response.Write("return value is "+ inval.Value);
-
Please help me out in getting the procedure execute in my C# code.
thanks in advance
Raj
