SET_IDENTIFIER

The SET_IDENTIFIER procedure is used to set the client ID in a session.

Syntax

DBMS_SESSION.SET_IDENTIFIER (
client_id VARCHAR2);

Parameters

client_id specifies the application identifier for the current database session (case-sensitive). The maximum number of bytes allowed for this parameter is 64. If the input value exceeds 64 bytes, the extra bytes will be truncated.

Considerations

The SET_IDENTIFIER procedure sets the client ID of the session to the specified value. It can also be used to identify the session through the function SYS_CONTEXT('USERENV','CLIENT_IDENTIFIER').

The SET_IDENTIFIER procedure can be executed by PUBLIC.

Examples

BEGIN
  DBMS_SESSION.SET_IDENTIFIER('1234');
END;