Invalid Packages WWV_FLOW_JOB and WWV_FLOW_PLSQL_JOB After APEX Upgrade (Doc ID 1076971.1)

Last updated on NOVEMBER 14, 2016

Applies to:

Oracle Application Express (formerly HTML DB) - Version 3.0.0.0.20 and later
Information in this document applies to any platform.
***Checked for relevance on 17-Oct-2013***


Symptoms


After upgrading Application Express (ex. from 3.0 to 3.2), the DBA_REGISTRY shows that Application Express is invalid. A query against the DBA_OBJECTS table shows that there are two packages in invalid status:

APEX_030200.WWV_FLOW_JOB and APEX_030200.WWV_FLOW_PLSQL_JOB

A recompile of the packages fails with the following error:

SQL> ALTER PACKAGE APEX_030200.wwv_flow_job COMPILE BODY;

Warning: Package Body altered with compilation errors.

SQL> SHOW ERRORS;
Errors for PACKAGE BODY APEX_030200.WWV_FLOW_JOB:

LINE/COL ERROR
-------- -----------------------------------------------------------------
21/3 PL/SQL: SQL Statement ignored
21/15 PL/SQL: ORA-00942: table or view does not exist
82/3 PL/SQL: SQL Statement ignored
84/10 PL/SQL: ORA-00942: table or view does not exist



 

 



 

Cause

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