PLS-00201: identifier 'CTX_DDL' must be declared (Doc ID 1315396.1)

Last updated on JULY 10, 2017

Applies to:

Oracle Text - Version 10.2.0.1 to 11.2.0.2 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 2-Sep-2014***

Symptoms

Creating a procedure that calls CTX_DDL.SYNC_INDEX completes with compilation errors:

SQL> CREATE OR REPLACE PROCEDURE syncidx(nomindex IN VARCHAR2)
  2  IS
  3    nb INT;
  4  BEGIN
  5    ctx_ddl.sync_index(nomindex,'200M');
  6  END;
  7  /

Warning: Procedure created with compilation errors.

SQL> show errors
Errors for PROCEDURE SYNCIDX:

LINE/COL ERROR
-------- -----------------------------------------------------------------
5/3      PL/SQL: Statement ignored
5/3      PLS-00201: identifier 'CTX_DDL' must be declared


However, manually sync'ing a Text index from SQLPLUS completes without errors:

SQL> exec ctx_ddl.sync_index('quick_text')

PL/SQL procedure successfully completed.

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