How to call PL/SQLProcedure form C#
736358Feb 23 2012 — edited Feb 29 2012Just need a simple C# method to execute a PL/SQL SP (Stored Procedure). I'm getting a recursion error, however my table is only 50 rows. I am able to execute the SP in TOAD perfectly, it takes about 1 second to process. I don't require parameter return values.
OracleCommand cmd = new OracleCommand();
cmd.Connection = connection;
cmd.CommandText = "HDWSTG_ADMIN.SI_MASTER_UPDATE_SP2";
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("reccount", OracleType.Number);
//cmd.Parameters["reccount"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
//cmd.ExecuteOracleNonQuery();
connection.Close();
Console.WriteLine(cmd.Parameters["reccount"].Value);
Thanks!