After Upgrade to Oracle 12c Some Packages Fail With ORA-07445 [qkaconReferencedCols()+435]
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 12.1]
Information in this document applies to any platform.
After upgrading to Oracle 22.214.171.124 some user schema packages fail to execute, returning error ORA-3113 to the user.
The alert log reports the following error:
The failing SQL statement in the trace file involves a connect by and a correlated select list subquery, e.g:
The call stack in the trace file includes functions like:
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