The STATUS Of Oracle Text In DBA_REGISTRY=INVALID; CTXSYS.DRIOPT Package Body Is INVALID - Compilation Errors = ORA-942 PLS-364: loop index variable 'COL' use is invalid (Doc ID 1499153.1)

Last updated on JUNE 19, 2017

Applies to:

Oracle Text - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

When upgrading from 11.2.0.2.0 to 11.2.0.3.0 via the Database Upgrade Assistant (DBUA), catupgrd.sql fails with the following errors leaving the STATUS of Oracle Text INVALID:

     "...
     ... loading driopt.plb
     @@driopt.plb
     create or replace package body driopt wrapped
     ...
     72 /

     Warning: Package Body created with compilation errors.

     show errors
     Errors for PACKAGE BODY DRIOPT:

     LINE/COL ERROR
     -------- -----------------------------------------------------------------
     523/3 PL/SQL: SQL Statement ignored
     523/40 PL/SQL: ORA-00942: table or view does not exist
     527/3 PL/SQL: SQL Statement ignored
     527/40 PL/SQL: ORA-00942: table or view does not exist
     553/3 PL/SQL: SQL Statement ignored
     553/38 PL/SQL: ORA-00942: table or view does not exist
     564/15 PL/SQL: SQL Statement ignored
     564/39 PL/SQL: ORA-00942: table or view does not exist
     566/5 PL/SQL: Statement ignored
     566/9 PLS-00364: loop index variable 'COL' use is invalid
     614/3 PL/SQL: SQL Statement ignored
     614/58 PL/SQL: ORA-00942: table or view does not exist

     ...

     Oracle Database 11.2 Post-Upgrade Status Tool 09-13-2012 10:13:12
     .
     Component Current Version Elapsed Time
     Name Status Number HH:MM:SS
     ...
     Oracle Text
     . INVALID 11.2.0.3.0 00:00:27
     ..."

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