Read Original Values and Display : dbms_application_info « System Packages « Oracle PL/SQL Tutorial






SQL>
SQL> SET SERVEROUTPUT ON SIZE 1000000
SQL> DECLARE
  2     lv_module_txt VARCHAR2(48);
  3     lv_action_txt VARCHAR2(32);
  4  BEGIN
  5
  6     DBMS_APPLICATION_INFO.READ_MODULE(lv_module_txt, lv_action_txt);
  7     DBMS_OUTPUT.PUT_LINE('Before  Module: ' || lv_module_txt ||
  8        CHR(9) || ' Action: ' || lv_action_txt);
  9     DBMS_APPLICATION_INFO.SET_MODULE('PL/SQL BLock',
 10        'Testing DBMS_APPLICATION_INFO');
 11  END;
 12  /
Before  Module: 9        Action:

PL/SQL procedure successfully completed.








31.2.dbms_application_info
31.2.1.Read Changed Values and Display
31.2.2.Read Original Values and Display
31.2.3.desc v$session_longops
31.2.4.dbms_application_info.set_client_info to change client information
31.2.5.dbms_application_info.set_client_info and dbms_application_info.set_action
31.2.6.dbms_application_info.set_client_info
31.2.7.DBMS_APPLICATION_INFO.SET_MODULE