I have a CSHTML page using System.Data.OracleClient below.

OracleCommand myCMD1 = new OracleCommand();
myCMD1.Connection = Oraclecon;
myCMD1.CommandText = "FNC_TEST";
myCMD1.CommandType = CommandType.StoredProcedure;
myCMD1.Parameters.Add("ret_cursor", OracleType.Cursor).Direction = ParameterDirection.Output;

I can get cursors out from FNC_TEST if FNC_TEST has no insert statements inside it. Once I add insert/update or delete statements inside the cursor it stops working. What's the proper way of invoking it from a CSHTML page ?

Related posts

Recent Viewed