My Oracle Support Banner

Invalid Package WWV_FLOW_SC_TRANSACTIONS after recompiling OWA packages (Doc ID 1484498.1)

Last updated on AUGUST 06, 2019

Applies to:

Oracle Application Express (APEX) - Version 3.2.1 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

After upgrading the database from 10g to 11g, accessing the APEX Admin page is getting a HTTP-404 error and in the error.log on the HTTP Server used to access APEX the following error is seen:

 

The output from the APEX verification script (apex_verify_output.html from Note  1254932.1) showed several invalid objects for the APEX installation. The utlrp.sql script was run and most of the objects are valid except WWV_FLOW_SC_TRANSACTIONS. When compiling the package  the same ORA-06502 / invalid number error is given for the get_page procedure.

 

 

Changes

 The database has recently been upgraded from 10g to 11.2.0.3, and the OWA packages were recently recompiled

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
Changes
Cause
Solution
References

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