GetOpContext Function

This function returns the context of the current operation.

Syntax

DBMS_WM.GetOpContext (
RETURN VARCHAR2;

Usage Notes

This function returns one of the following values:

• DML: The current operation is driven by data manipulation language (DML) initiated by the user.

• MERGE_REMOVE: The current operation was initiated by a MergeWorkspace Procedure call with remove_workspace as TRUE or a MergeTable Procedure call with remove_data as TRUE.

• MERGE_NOREMOVE: The current operation was initiated by a MergeWorkspace Procedure call with remove_workspace as FALSE or a MergeTable Procedure call with remove_data as FALSE.

Examples

The following example displays the context of the current operation.

SELECT DBMS_WM.GetOpContext FROM DUAL;

GETOPCONTEXT                                                                     
--------------------------------------------------------------------------------
DML