Getting ORA-01858 Error Executing Procedure in SQL ID
(Doc ID 242455.1)
Last updated on DECEMBER 03, 2019
Applies to:Oracle Financial Data Manager - Version 4.5 to 4.5.40 [Release 4.5]
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document