APEX_040000.WWV_FLOW_HELP Package Body Is Invalid; Compilation=PLS-201 On CTX_DDL (Doc ID 1312938.1)

Last updated on SEPTEMBER 13, 2012

Applies to:

Oracle Text - Version 10.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 14-Sep-2012***

Symptoms


The APEX_040000.WWV_FLOW_HELP package body is invalid:

SQL> select owner, count(*)
  2    from dba_objects
  3    where status != 'VALID'
  4    group by owner;

OWNER                  COUNT(*)
-------------------- ----------
APEX_040000                   1

SQL> select owner, object_name, object_type, status
  2    from dba_objects
  3    where object_name = 'WWV_FLOW_HELP'
  4    order by 1,2,3;

OWNER           OBJECT_NAME     OBJECT_TYPE               STATUS
--------------- --------------- ------------------------- ---------------
APEX_040000     WWV_FLOW_HELP   PACKAGE                   VALID
APEX_040000     WWV_FLOW_HELP   PACKAGE BODY              INVALID
PUBLIC          WWV_FLOW_HELP   SYNONYM                   VALID

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