The READ_MODULE procedure reads the values of the module and operation fields of the current session.
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. |
Usage notes
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