Oracle | CTX

Oracle CTX_ANL Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose According to the Oracle Text Reference online doc the CTX_ANL PL/SQL package is used with AUTO_LEXER and provides procedures for adding and dropping a custom dictionary from the lexer. A custom dictionary might be one that you develop for a special field of study or for your industry. In most cases, the dictionaries supplied with Oracle Text are more than sufficient to handle your requirements.

AUTHID CURRENT_USER

Dependencies

CTX_DDL	DRUE	DRVUTL
DRIUTL	DRVLSB	DR_DEF

Documented Yes: Packages and Types Reference

First Available Not known

Security Model Owned by CTXSYS with EXECUTE granted to the CTXAPP role.

Source {ORACLE_HOME}/ctx/admin/dr0anl.plb

Subprograms

ADD_DICTIONARY

DROP_DICTIONARY

ADD_DICTIONARY

Used to add a custom dictionary for use by the AUTO_LEXER ctx_anl.add_dictionary( name IN VARCHAR2, language IN VARCHAR2, dictionary IN CLOB);

DECLARE

       dict_str CLOB := 'A' || CHR(9) || 'B' || CHR(9) || 'C' || CHR(9);

      BEGIN

       
      ctx_anl.add_dictionary('UWLEXDICT', 'ENGLISH', dict_str);

      END;

      /

      

      PL/SQL procedure successfully completed.

DROP_DICTIONARY

Drops a custom dictionary from the AUTO_LEXER ctx_anl.drop_dictionary(name IN VARCHAR2);

exec ctx_anl.drop_dictionary('UWLEXDICT');

      

      PL/SQL procedure successfully completed.

Morgan's Library Page Footer

This site is maintained by Daniel Morgan. Last Updated: