The CLEAR_ALL_CONTEXT procedure clears all application context information in the specified namespace.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_SESSION.CLEAR_ALL_CONTEXT
(namespace VARCHAR2);
Parameters
The namespace parameter specifies the namespace from which the application context information is to be cleared.
Considerations
The CLEAR_ALL_CONTEXT procedure must be directly or indirectly called by a trusted package.
Changes made by using the CLEAR_ALL_CONTEXT procedure in context value take effect immediately and subsequent calls to access the value by using the SYS_CONTEXT function return the latest value.
Examples
BEGIN
DBMS_SESSION.CLEAR_ALL_CONTEXT('emp_context');
END;