The READ_CLIENT_INFO procedure is used to read the value of the client_info field for the current session.
Syntax
DBMS_APPLICATION_INFO.READ_CLIENT_INFO (
OUT client_info VARCHAR(65535));
Parameters
The client_info parameter is used to provide the latest client information values to the SET_CLIENT_INFO procedure.
Examples
obclient> DECLARE
myclient VARCHAR(65535);
mymodule VARCHAR(65535);
myaction VARCHAR(65535);
BEGIN
DBMS_APPLICATION_INFO.SET_CLIENT_INFO('OBClient');
DBMS_APPLICATION_INFO.READ_CLIENT_INFO(myclient);
SELECT myclient AS client;
DBMS_APPLICATION_INFO.SET_MODULE('OBmodule', 'inserting');
DBMS_APPLICATION_INFO.READ_MODULE(mymodule, myaction);
SELECT mymodule AS module_name, myaction AS action_name;
END;