CLEAR_ALL_CONTEXT

The CLEAR_ALL_CONTEXT procedure is used to clear the application context information in the specified namespace.

Syntax

DBMS_SESSION.CLEAR_ALL_CONTEXT
    (namespace         VARCHAR2);

Parameters

namespace specifies the namespace of the application context information to be cleared.

Considerations

The CLEAR_ALL_CONTEXT procedure must be called directly or indirectly by a trusted package.

Any changes to the context values made by the CLEAR_ALL_CONTEXT procedure will take effect immediately. Subsequent calls to SYS_CONTEXT will return the updated value.

Examples

BEGIN
  DBMS_SESSION.CLEAR_ALL_CONTEXT('emp_context');
END;