The CLEAR_ALL_CONTEXT procedure clears all application context information in the specified namespace.
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.
Usage notes
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;