The READ_CLIENT_INFO procedure reads the value of the client_info field of the current session.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_APPLICATION_INFO.READ_CLIENT_INFO (
client_info OUT VARCHAR2);
Parameters
The client_info parameter provides the latest client information for the SET_CLIENT_INFO procedure.
Examples
DECLARE
myclient VARCHAR2(50);
mymodule VARCHAR2(50);
myaction VARCHAR2(50);
BEGIN
DBMS_APPLICATION_INFO.SET_CLIENT_INFO('OBClient');
DBMS_APPLICATION_INFO.READ_CLIENT_INFO(myclient);
DBMS_OUTPUT.PUT_LINE ('client='||myclient);
DBMS_APPLICATION_INFO.SET_MODULE('OBmodule','inserting');
DBMS_APPLICATION_INFO.READ_MODULE(mymodule,myaction);
DBMS_OUTPUT.PUT_LINE('mod_name='||mymodule);
DBMS_OUTPUT.PUT_LINE('act_name='||myaction);
END;
client=OBClient
mod_name=OBmodule
act_name=inserting