SET_CONTEXT Procedure

This procedure sets or resets the value of a context attribute.

Syntax

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

Parameters

Table 58-16 SET_CONTEXT Procedure Parameters

Parameter	Description
namespace	Name of the namespace to use for the application context (limited to 30 bytes).
attribute	Name of the attribute to be set (limited to 30 bytes).
value	Value to be set (limited to 4 kilobytes).
username	The username attribute of the application context
client_id	The application-specific identifier of the current database session.

Usage Notes

The caller of this function must be in the calling stack of a procedure which has been associated to the context namespace through a CREATE CONTEXT statement. The checking of the calling stack does not cross DBMS boundary.

There is no limit on the number of attributes that can be set in a namespace. An attribute value remains for user session, or until it is reset by the user.