The SET_IDENTIFIER procedure sets a client ID in the session.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_SESSION.SET_IDENTIFIER (
client_id VARCHAR2);
Parameters
The client_id parameter specifies the client ID of the current database session. The client ID is case-sensitive. The client ID contains a maximum of 64 bytes in length. If the client ID exceeds 64 bytes, the excess bytes will be truncated.
Considerations
The SET_IDENTIFIER procedure is used to set the client ID of a session to the specified value. It can also be used to identify a session by using the SYS_CONTEXT('USERENV','CLIENT_IDENTIFIER') function.
The SET_IDENTIFIER procedure can be executed by using the PUBLIC keyword.
Examples
BEGIN
DBMS_SESSION.SET_IDENTIFIER('1234');
END;