My Oracle Support Banner

The WWV_FLOW_HELP PACKAGE Status is Invalid After Installing Oracle Text (Doc ID 1335521.1)

Last updated on AUGUST 04, 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.


To view full details, 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 a vibrant support community of peers and Oracle experts.