My Oracle Support Banner

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

Last updated on APRIL 18, 2019

Applies to:

Oracle Text - Version 10.2.0.4 to 12.2.0.1 [Release 10.2 to 12.2]
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.