The SET_CLIENT_INFO procedure sets additional information for the client application.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_APPLICATION_INFO.SET_CLIENT_INFO (
client_info IN VARCHAR2);
Parameters
The client_info parameter stores all additional information about the client application. Such information is stored in the __all_virtual_processlist table. The part exceeding 64 bytes will be truncated.
Examples
DECLARE
myclient VARCHAR2(100);
...
BEGIN
...
DBMS_APPLICATION_INFO.SET_CLIENT_INFO('myclient');
DBMS_OUTPUT.PUT_LINE ('client='||myclient);
END;