DDL Statement On Java Stored Procedure Fails With ORA-04043/ORA-00600 /ORA-07445[joxrv11_invalidate] After Upgrade To 12.2
(Doc ID 2350169.1)
Last updated on JULY 07, 2022
Applies to:Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.
Following Java source was created in a 12.1.0.x database
The database was upgraded from 12.1.0.x to 18.104.22.168 with COMPATIBLE parameter set to 12.2.0
The issue can also be observed after a PDB is unplugged from 12.1.0.x environment and plugged into 22.214.171.124 environment with COMPATIBLE set to 12.2.0 resulting in an automatic increase of the PDB COMPATIBLE parameter to the same parameter setting at CDB$ROOT.
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