PL/SQL numeric or value error
Hello all,
I have this error at the customer's site, after deploying my application.
The stored procedure called is something like:
OracleCommand cmd = new OracleCommand(
"begin \n" +
ApplicationSchema + ".IAccessOra.GetFormScript(:IdForm, :DdScript, :Azione, 1); \n " +
"end;", MainSession);
cmd.CommandType = CommandType.Text;
cmd.BindByName = true;
cmd.Parameters.Add("IdForm", OracleDbType.Decimal, IdForm, ParameterDirection.Input);
cmd.Parameters.Add("DdScript", OracleDbType.Clob, 32000, DBNull.Value, ParameterDirection.Output);
cmd.Parameters.Add("Azione", OracleDbType.Varchar2, 10, GlobalMembers.cScriptEventId[(int)Evento], ParameterDirection.Input);
It seems the situation of bug 4015165, but the error is systematic, not intermittent.
But when I tried to build a test case I failed. The same function which fails in the main project, works or has intermittent errors when set aside in another project.
In office everything works.
Environment:
customer:
database 9206 client 10.2.0.4 win 2003 R2 standard sp 2 (virtual with vmware)
office
database 9207 client 10.2.0.4 and odp.net 11 win 2003 R2 standard sp 2 (virtual with vmware)
In office I have never seen this error, and I have 9207, so
I asked the customer to patch his database to 9207 or 9208.
Is this advice reasonable in your opinion ?
Btw I tried to enable odp.net trace at the customer site but it doesn't generate the trace file. Could it depend on the fact that the server
is virtual ?
Thanks for any idea/advice/tip
Bye
Nicola