Proc execution failed from CS code
Hi,
I have a piece of code which call a proc to update a table. The problem is that it is not updating table and it doesn't throw any error. I'm totally confused as to what kindof problem is this.
The proc def:
Code:
CREATE OR REPLACE PROCEDURE Updateincidentlov (
errcode OUT INT,
pid TBL.id%TYPE,
pdesc TBL.desc%TYPE,
pstatus TBL.status%TYPE,
porder TBL.order%TYPE
)
The CS code:
Code:
public int Update(String Desc, int Order, int status, int Id)
{
OracleConnection conn = this.CreateConnection();
OracleTransaction transaction = conn.BeginTransaction();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Transaction = transaction;
cmd.CommandText = "UPDATETABLE";
OracleParameter param1 = new OracleParameter("errcode", OracleType.Int32);
param1.Direction = ParameterDirection.Output;
OracleParameter param2 = new OracleParameter("pid", OracleType.Number);
param2.Value = Id;
param2.Direction = ParameterDirection.Input;
OracleParameter param3 = new OracleParameter("pdesc", OracleType.VarChar);
param3.Value = Desc;
param3.Size = 4000;
param3.Direction = ParameterDirection.Input;
OracleParameter param4 = new OracleParameter("pstatus", OracleType.Number);
param4.Value = status;
param4.Direction = ParameterDirection.Input;
OracleParameter param5 = new OracleParameter("porder", OracleType.Number);
param5.Value = Order;
param5.Direction = ParameterDirection.Input;
cmd.Parameters.Add(param1);
cmd.Parameters.Add(param2);
cmd.Parameters.Add(param3);
cmd.Parameters.Add(param4);
cmd.Parameters.Add(param5);
int errCode = cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
conn.Dispose();
return errCode;
}
------------------------------------------------------------------------------------------------------------
Adventure, Play, Alive, Fast, Race, Addict, React, Attack, Heat, Aggression, Blast, Ahead, Escape, Challenge, Anarchy, Game, Real, Damage, Insane, Acclerate,Passion, Fear, Dominate, Crazy, Awesome, Sweat, Habit, Avenge, Balls, Imagine, Viril, Chaos, Amuse, Heavy, Panic, @#!%, Fanatic
__________________
------------------------------------------------------------------------------------------------------------
<b><i>Adventure, Play, Alive, Fast, Race, Addict, React, Attack, Heat, Aggression, Blast, Ahead, Escape, Challenge, Anarchy, Game, Real, Damage, Insane, Acclerate,Passion, Fear, Dominate, Crazy, Awesome, Sweat, Habit, Avenge, Balls, Imagine, Viril, Chaos, Amuse, Heavy, Panic, @#!%, Fanatic </i></b>
|
