We have an Oracle 126.96.36.199.0 database and get the ORA-01858: a non-numeric character was found where a numeric was expected error.
Our production jobs are a series of stored procedures which are set up to run automatically by being called through another stored procedure, the Scheduler. While the Scheduler is running, two of them have the above error. However, when these two jobs are run as stand alone procedures they run successfully. Do you have any suggestions why this is happening and how to stop it?
April 10, 2008 3:05 PM
August 4, 2010 5:20 AM