Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.8K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.2K SQL Developer
- 295.3K Development
- 17 Developer Projects
- 138 Programming Languages
- 292K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 27 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 390 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1K Español
- 1.9K Japanese
- 230 Portuguese
PL/SQL numeric or value error

Nicola Farina
Member Posts: 44
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
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
Tagged:
Answers
-
Hi Nicola,
I think that asking your customer to apply a later patchset is a reasonable request. There is a one-off patch available for 9.2.0.6 for this particular issue as well (assuming this is the real cause).
I have not had issues with odp.net trace not working in a virtual machine.
Not sure that is much help, but maybe...
Regards,
Mark -
Hi Mark
Thanks for answering.
About the tracefile problem ...
Actually even my test machine in office is a virtual one, so certainly it is not the problem.
I simply edited the TraceLevel key in the registry to enable the trace (I putted the value 9).
I have done the same thing on my test machine and on the client machine.
But on the latter the trace file doesn't get generated while on the first it works perfectly ....
Have you ever seen a problem like this ?
Bye
Nicola -
Hi Nicola,
Sorry, I have not seen that problem before. I assume the TraceFileName is valid, etc...
Mark -
Hi,
I've seen tracing not work on older versions of ODP when the OraOps10.dll was moved outside of the Oracle home\bin. Are all your oraops.dll's in the right place?
Hope it helps,
Greg -
Hi Greg
I haven't moved any file but I'll check this file, thanks.
Mark
Yes, parameters in registry are all ok. Filename is the default (something like c:\odpxx.trc). For test I tried specify another path but with
no success. Usually setting the TraceLevel is enough to enable the trace (or at least I've always done this way)..
Thanks anyway
Bye
Nicola
This discussion has been closed.