My Oracle Support Banner

Getting ORA-01858 Error Executing Procedure in SQL ID (Doc ID 242455.1)

Last updated on JUNE 05, 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)
SQL ID

Symptoms

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.

Cause

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
Symptoms
Cause
Solution

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