I am encountering the following errors when trying to create an Oracle Text preference or set an attribute on Oracle Database Free 23ai (23.4) (installed with Windows installer) and with the Virtual Box prebuilt VM. However, I do not experience this error on Oracle Autonomous Cloud Database 23ai and previous versions of Oracle Database.
PLS-00201: identifier 'CTX_DDL.CREATE_PREFERENCE' must be declared
PLS-00201: identifier 'CTX_DDL.SET_ATTRIBUTE' must be declared
Executing as system connected to FREEPDB1.
Here is a test executing a sample from the Oracle Database documentation:
SQL> begin
2 ctx_ddl.create_preference('my_lexer', 'BASIC_LEXER');
3 ctx_ddl.set_attribute('my_lexer', 'INDEX_TEXT', 'YES');
4 ctx_ddl.set_attribute('my_lexer', 'INDEX_THEMES', 'NO');
5 end;
6 /
ctx_ddl.create_preference('my_lexer', 'BASIC_LEXER');
*
ERROR at line 2:
ORA-06550: line 2, column 1:
PLS-00201: identifier 'CTX_DDL.CREATE_PREFERENCE' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
ORA-06550: line 3, column 1:
PLS-00201: identifier 'CTX_DDL.SET_ATTRIBUTE' must be declared
ORA-06550: line 3, column 1:
PL/SQL: Statement ignored
ORA-06550: line 4, column 1:
PLS-00201: identifier 'CTX_DDL.SET_ATTRIBUTE' must be declared
ORA-06550: line 4, column 1:
PL/SQL: Statement ignored