Getting ORA-01858 Error Executing Procedure in SQL ID
Last updated on MARCH 09, 2017
Applies to:Oracle Financial Data Manager - Version 4.5 to 4.5.40 [Release 4.5]
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA)
In Oracle Balance and Control (BC) 4.5, you get the following error when executing a procedure in a SQL ID:
ORA-01858: a non-numeric character was found where a numeric was expected
The SQL statement referenced in the error message references a date field.
You can execute the procedure successfully in SQL*Plus.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms