SET_CONTEXT

The SET_CONTEXT procedure sets the context, which includes four types: session-local, global initialization, external initialization, and global access.

Syntax

DBMS_SESSION.SET_CONTEXT (
namespace VARCHAR2,
attribute VARCHAR2,
value     VARCHAR2,
username  VARCHAR2,
client_id VARCHAR2 );

Parameters

Considerations

• The username parameter must be a valid SQL identifier.

• The client_id parameter must be a string of up to 64 bytes. It is case-sensitive and must match the value provided by the set_identifier parameter.

• If the namespace parameter specifies a global context namespace, the username parameter must match the current database username in the session, and the client_id parameter must match the current client_id in the session. If these parameters are not set, they are considered NULL, allowing any user to view the context value.

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

• If a parameter value is already set in the namespace, SET_CONTEXT will overwrite the existing value.

• Changes to context values made by the SET_CONTEXT procedure take effect immediately. Subsequent calls to SYS_CONTEXT will return the updated value.

Examples

CREATE PROCEDURE emp_attr(empname IN VARCHAR2, empno IN NUMBER) IS
BEGIN
   DBMS_SESSION.SET_CONTEXT('emp_context',empname, empno);
END;