The SET_CLIENT_INFO procedure is used to set additional information for the client application.
Syntax
DBMS_APPLICATION_INFO.SET_CLIENT_INFO (
IN client_info VARCHAR(65535));
Parameters
The client_info parameter stores any additional information about the client application. This information is stored in the __all_virtual_processlist table. If the length of the information exceeds 64 bytes, it will be truncated.
Examples
obclient> DECLARE
myclient VARCHAR(65535);
BEGIN
DBMS_APPLICATION_INFO.SET_CLIENT_INFO('myclient');
DBMS_APPLICATION_INFO.READ_CLIENT_INFO(myclient);
SELECT myclient AS client;
END;