<pre lang="sql">else
{
//str.Append(o_Qry_Security.qry_UpdateGroupID_UserRightsMaster(User_Master_ID, Convert.ToInt32(SessionCheck.s_sessionusergroupid))); // COMMENTED ON 29-07 Vinodita
o_Qry_Security.qry_UpdateGroupID_UserRightsMaster(User_Master_ID,t_MAKERDATETIME, Convert.ToInt32(SessionCheck.s_sessionusergroupid));
}</pre>
public void qry_UpdateGroupID_UserRightsMaster(int usermasterinternalid, string MAKERDATETIME,int makerid)
{
//StringBuilder strBuilder = new StringBuilder();
//strBuilder.Append(" UPDATE USER_RIGHTS_MASTER ");
//strBuilder.Append(" SET ");
//strBuilder.Append(" MAKER_ID =:makerid , ");
//strBuilder.Append(" MAKER_DATETIME = TO_DATE(:MAKERDATETIME, 'DD-MM-YYYY') WHERE ID =: usermasterinternalid ");
//s_dsnstr = o_Cls_Utility.utl_fnGetDSNStr(SessionCheck.s_sessiondpid);
//OracleConnect o_Cls_OracleConnect = new OracleConnect(s_dsnstr);
//o_Cls_OracleConnect.OracleCommand_PreInit(strBuilder.ToString());
//o_Cls_OracleConnect.Parameter_Int32("MAKER_ID", makerid);
//o_Cls_OracleConnect.Parameter_String("MAKERDATETIME", MAKERDATETIME);
//o_Cls_OracleConnect.Parameter_Int32("usermasterinternalid", usermasterinternalid);
//o_Cls_OracleConnect.ExecNonQuery();
//strBuilder.Remove(0, strBuilder.Length);
StringBuilder strBuilder = new StringBuilder();
strBuilder.Append(" UPDATE USER_RIGHTS_MASTER ");
strBuilder.Append(" SET ");
strBuilder.Append(" MAKER_ID =:makerid , ");
strBuilder.Append(" MAKER_DATETIME = TO_DATE(:MAKERDATETIME, 'DD-MM-YYYY') WHERE ID =: usermasterinternalid ");
s_dsnstr = o_Cls_Utility.utl_fnGetDSNStr(SessionCheck.s_sessiondpid);
OracleConnect o_Cls_OracleConnect = new OracleConnect(s_dsnstr);
o_Cls_OracleConnect.OracleCommand_PreInit(strBuilder.ToString());
o_Cls_OracleConnect.Parameter_Int32("MAKER_ID", makerid);
o_Cls_OracleConnect.Parameter_String("MAKERDATETIME", MAKERDATETIME);
o_Cls_OracleConnect.Parameter_Int32("usermasterinternalid", usermasterinternalid);
o_Cls_OracleConnect.ExecNonQuery();
strBuilder.Remove(0, strBuilder.Length);
}
public void ExecNonQuery()
{
try
{
MyCmd.Transaction = MyTrans;
MyCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MyTrans.Rollback();
throw ex;
}
finally
{
if (!(MyCmd == null))
{
MyCmd.Dispose();
}
MyCmd = null;
}
}
I get an error at catch statement :ORA-01036: illegal variable name/number