The READ_MODULE procedure is used to read the values of the module and operation fields for the current session.
Syntax
DBMS_APPLICATION_INFO.READ_MODULE (
OUT module_name VARCHAR(65535),
OUT action_name VARCHAR(65535));
Parameters
Parameter |
Explanation |
|---|---|
| module_name | CallSET_MODULEThe procedure sets the module name to its latest value. |
| action_name | By callingSET_ACTIONorSET_MODULEThe procedure sets the operation name to its latest value. |
Usage instructions
You can call the READ_MODULE procedure to retrieve the module and operation names of registered applications. You can also call the READ_CLIENT_INFO procedure to retrieve client information.
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;