Invalid Package WWV_FLOW_SC_TRANSACTIONS after recompiling OWA packages
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 220.127.116.11, 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