Getting ORA-01455 Running Union SQL in OFSA After Upgrade to 188.8.131.52 or Higher
Last updated on FEBRUARY 18, 2016
Applies to:Oracle Financial Data Manager - Version 4.5.39 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5.39
After upgrading the OFSA database to Oracle 184.108.40.206 or a higher version, you receive the following error when running a SQL statement containing a UNION clause in SQL Talk:
(203105) Oracle drv_oci error:
OCI Function:  - ofetch(), ofen()
SQL Function:  - SELECT
Oracle Error: ORA-01455: converting column overflows integer datatype
Driver Function: drv_oci::FetchNext()
The same SQL statement runs successfully in SQL*Plus. Additionally, if you break the Union SQL into two separate pieces and run each individually, each piece runs successfully in SQL Talk by itself. The error only occurs when the "Union" clause is added.
You have already made the init.ora changed recommended in My Oracle Support <Document 258083.1> "Cannot Query Numeric Field with No Specified Scale in SQLTALK in RDBMS 9i" and the error still occurs.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms