I am a database user of Oracle 11.2.0.3 on Linux RH V6.
I have a java developer who is running a query that fails with the following error:
java.sql.SQLException: ORA-25137: Data value out of range
Please note that this error only occurs when running in the production database when called by the java application.
It runs successfully when using SQL Developer and SQL Plus.
It also runs successfully in the test environment from all sources (NO ISSUES WITH THE JAVA APP).
has anyone seen this behavior before?
Thanks in advance.
Beth