My Oracle Support Banner

PLS-00201: Identifier 'CTX_DDL.CREATE_PREFERENCE' after applying patch 25872779 (Doc ID 2283549.1)

Last updated on JANUARY 17, 2020

Applies to:

Oracle Text - Version 12.1.0.2 and later
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.0.2 version, Creating/Maintaining context indexes

PLS-00201: identifier 'CTX_DDL.CREATE_PREFERENCE' after applying patch 25872779

Validating logfiles...
Patch 25872779 apply: WITH ERRORS
  logfile: O:\Oracle\cfgtoollogs\sqlpatch\25872779\21307635/25872779_apply_WINDQA_2017Jun30_15_32_20.log (errors)
  Error at line 813: ORA-06550: line 2, column 3:
  Error at line 814: PLS-00201: identifier 'CTX_DDL.CREATE_PREFERENCE' must be declared
  Error at line 815: ORA-06550: line 2, column 3:
  Error at line 817: ORA-06550: line 3, column 3:
  Error at line 818: PLS-00201: identifier 'CTX_DDL.SET_ATTRIBUTE' must be declared

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.