Oracle 18cR3 CTX

Oracle CTX_ANL Version 18.3.0.1

General Information

Library Note

Morgan's Library Page Header

Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't make it this year, check out TidalScale at www.tidalscale.com. Be sure to click on the Solutions link and look through the Oracle resources.

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

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);

SQL> 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');