My Oracle Support Banner

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.