My Oracle Support Banner

"PLS-00201: identifier 'CTX_DDL' must be declared" Error During Agile Product Lifecycle Management (PLM) Upgrade (Doc ID 2880519.1)

Last updated on JUNE 30, 2022

Applies to:

Oracle Agile PLM Framework - Version 9.3.5.0 to 9.3.6.0 [Release 9.3]
Information in this document applies to any platform.

Symptoms

When running the agile9_ctx_recreate.sql script, the following issue is observed:

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY AGILE_SERVER_FTS:

LINE/COL ERROR
-------- -----------------------------------------------------------------
6/4 PL/SQL: Statement ignored
6/4 PLS-00201: identifier 'CTX_DDL' must be declared
14/4 PL/SQL: Statement ignored
14/4 PLS-00201: identifier 'CTX_DDL' must be declared
15/4 PL/SQL: Statement ignored
15/4 PLS-00201: identifier 'CTX_DDL' must be declared
20/4 PL/SQL: Statement ignored
20/4 PLS-00201: identifier 'CTX_DDL' must be declared
25/4 PL/SQL: Statement ignored
25/4 PLS-00201: identifier 'CTX_DDL' must be declared
30/4 PL/SQL: Statement ignored
30/4 PLS-00201: identifier 'CTX_DDL' must be declared
35/4 PL/SQL: Statement ignored
35/4 PLS-00201: identifier 'CTX_DDL' must be declared
40/4 PL/SQL: Statement ignored
40/4 PLS-00201: identifier 'CTX_DDL' must be declared
45/4 PL/SQL: Statement ignored
45/4 PLS-00201: identifier 'CTX_DDL' must be declared
50/4 PL/SQL: Statement ignored
50/4 PLS-00201: identifier 'CTX_DDL' must be declared
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.15.0.0.0



Changes

Upgrade from 9.3.5 to 9.3.6 

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
Changes
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.