The READ_MODULE procedure is used to retrieve the values of the module and action fields for the current session.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Syntax
DBMS_APPLICATION_INFO.READ_MODULE (
module_name OUT VARCHAR2,
action_name OUT VARCHAR2);
Parameters
| Parameter | Description |
|---|---|
| module_name | The module name set by the SET_MODULE procedure. |
| action_name | The action name set by the SET_ACTION or SET_MODULE procedure. |
Considerations
You can call the READ_MODULE procedure to retrieve the module and action names of registered applications. 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