try
{
// ====ERP DB==============
OracleParameter[] parm1 = new OracleParameter[4];
parm1[0] = new OracleParameter("Param1", OracleType.NVarChar, 50);
parm1[1] = new OracleParameter("UserID", OracleType.NVarChar, 50);
parm1[2] = new OracleParameter("Direction", OracleType.NVarChar, 50);
parm1[3] = new OracleParameter("MSG", OracleType.NVarChar, 50);
parm1[0].Value = sMo;
parm1[1].Value = sUser;
parm1[2].Value = sDirection;
for (int i = 0; i < parm1.Length - 1; i++)
{
parm1[i].Direction = ParameterDirection.Input;
}
parm1[3].Direction = ParameterDirection.Output;
foreach (IDataParameter parameter in parm1)
{
commProc.Parameters.Add(parameter);
}
commProc.CommandText = "MES_EX.WO";
commProc.Transaction = tran;
OracleString result;
commProc.ExecuteOracleNonQuery(out result);
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
throw new Exception(ex.Message);
}
{
// ====ERP DB==============
OracleParameter[] parm1 = new OracleParameter[4];
parm1[0] = new OracleParameter("Param1", OracleType.NVarChar, 50);
parm1[1] = new OracleParameter("UserID", OracleType.NVarChar, 50);
parm1[2] = new OracleParameter("Direction", OracleType.NVarChar, 50);
parm1[3] = new OracleParameter("MSG", OracleType.NVarChar, 50);
parm1[0].Value = sMo;
parm1[1].Value = sUser;
parm1[2].Value = sDirection;
for (int i = 0; i < parm1.Length - 1; i++)
{
parm1[i].Direction = ParameterDirection.Input;
}
parm1[3].Direction = ParameterDirection.Output;
foreach (IDataParameter parameter in parm1)
{
commProc.Parameters.Add(parameter);
}
commProc.CommandText = "MES_EX.WO";
commProc.Transaction = tran;
OracleString result;
commProc.ExecuteOracleNonQuery(out result);
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
throw new Exception(ex.Message);
}