The WWV_FLOW_HELP PACKAGE Status is Invalid After Installing Oracle Text

(Doc ID 1335521.1)

Last updated on MARCH 30, 2018

Applies to:

Oracle Application Express (APEX) - Version and later
Information in this document applies to any platform.
Checked for relevance on 22-May-2014
Checked for relevance on 31-Mar-2018


After installing Oracle Text  the  WWV_FLOW_HELP package as follows :

SQL> alter package APEX_XXXXXX.WWV_FLOW_HELP compile;
SQL> alter package APEX_XXXXXX.WWV_FLOW_HELP compile body;

Where APEX_XXXXXX represents the schema for the current installation. E.g. APEX_030200 for APEX 3.2.x.

The package compile failed with the following errors:

SQL> show err

-------- -------------------------------------------------
191/13 PL/SQL: Statement ignored
191/13 PLS-00201: identifier 'CTX_DDL' must be declared
199/9 PL/SQL: Statement ignored
199/9 PLS-00201: identifier 'CTX_DDL' must be declared
261/5 PL/SQL: Statement ignored
261/5 PLS-00201: identifier 'CTX_DDL' must be declared
262/5 PL/SQL: Statement ignored
262/5 PLS-00201: identifier 'CTX_DDL' must be declared
265/9 PL/SQL: Statement ignored
265/9 PLS-00201: identifier 'CTX_DDL' must be declared
280/9 PL/SQL: Statement ignored

The status of WWV_FLOW_HELP package is invalid. And this problem is also occurred in other version of APEX.


New install of Oracle Text into an existing database.


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