PREFERENCE_IMPLICIT_COMMIT

This variable, set at the package level for CTX_DDL, determines whether procedures related to CTX_DDL preferences issue an implicit commit and is session duration.

You can set the PREFERENCE_IMPLICIT_COMMIT variable for the procedures listed in the following table.

Procedure Name	Procedure Name
ADD_ATTR_SECTION	CREATE_INDEX_SET
ADD_FIELD_SECTION	CREATE_PREFERENCE
ADD_INDEX	CREATE_SECTION_GROUP
ADD_MDATA_COLUMN	CREATE_STOPLIST
ADD_MDATA_SECTION	DROP_PREFERENCE
ADD_SDATA_COLUMN	DROP_SECTION_GROUP
ADD_SDATA_SECTION	DROP_STOPLIST
ADD_SPECIAL_SECTION	REMOVE_INDEX
ADD_STOPCLASS	REMOVE_SECTION
ADD_STOP_SECTION	REMOVE_SUB_LEXER
ADD_STOPTHEME	SET_ATTRIBUTE
ADD_STOPWORD	UNSET_ATTRIBUTE
ADD_SUB_LEXER	UPDATE_SUB_LEXER
ADD_ZONE_SECTION

Note: The REMOVE_STOPCLASS, REMOVE_STOPTHEME, and REMOVE_STOPWORD procedures do not issue an implicit commit, and, therefore, do not use the PREFERENCE_IMPLICIT_COMMIT flag.

Syntax

exec CTX_DDL.PREFERENCE_IMPLICIT_COMMIT := TRUE|FALSE ;

The default value of the PREFERENCE_IMPLICIT_COMMIT variable is TRUE. When this variable is set to FALSE, procedures related to CTX_DDL preferences will not issue an implicit commit. This enables you to easily rollback multiple preference changes. This variable is session duration.

Example

The following example turns off implicit commit.

exec CTX_DDL.PREFERENCE_IMPLICIT_COMMIT : update_sub_lexer = FALSE;