Invalid Package WWV_FLOW_SC_TRANSACTIONS after recompiling OWA packages

(Doc ID 1484498.1)

Last updated on MAY 24, 2016

Applies to:

Oracle Application Express (formerly HTML DB) - Version 3.2.1 and later
Information in this document applies to any platform.


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.




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


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