The size setting in the parameter is too small, so that the program cannot pass the correct value to the database for execution. Here, I would like to warn you that similar basic errors are rarely made.
Int returnvalue = 0;
String returnmsg = string. empty;
Try
{
Dbcon DBC = new dbcon ();
Oracleparameter [] parameters = new oracleparameter [] {DBC. creatoutpara ("o_returnvalue", oracletype. Number, 8 ),
DBC. creatoutpara ("o_returnmsg", oracletype. varchar, 30 ),
DBC. creatinpara ("I _woid", oracletype. varchar, 8, woid ),
DBC. creatinpara ("I _routingid", oracletype. varchar, 30, rightroutingid)
};
DBC. execproc ("adata_pac_abnormal.proc_correctrouting", parameters );
Returnvalue = int. parse (parameters [0]. value. tostring ());
Returnmsg = parameters [1]. value. tostring ();
}
Catch (exception ex)
{
Alert (getrequestfilename () + "An exception occurred when updating the database when the route was modified on the page. Exception information:" + ex. Message + "Contact mes personnel .");
Return;
}
If (returnvalue = 1)
{
Alert (returnmsg );
}
Else
{
Alert (returnmsg );
}
// Update the ticket and route information
Getruncardid (woid );