The READ_MODULE procedure reads the values of the module and operation fields 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_MODULE (
module_name OUT VARCHAR2,
action_name OUT VARCHAR2);
Parameters
Parameter |
Description |
|---|---|
| module_name | The SET_MODULE procedure is called to set the module name to the latest value. |
| action_name | The SET_ACTION or SET_MODULE procedure is called to set the operation name to the latest value. |
Considerations
The READ_MODULE procedure retrieves the module and operation names of a registered application. You can also call the READ_CLIENT_INFO procedure to retrieve client information.
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