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






  1. Oracle PL/SQL Tutorial
  2. System Packages
  3. dbms_application_info
SQL>
SQL>
SQL> SET SERVEROUTPUT ON SIZE 1000000
SQL> DECLARE
  2     lv_module_txt VARCHAR2(48);
  3     lv_action_txt VARCHAR2(32);
  4  BEGIN
  5     DBMS_APPLICATION_INFO.READ_MODULE(lv_module_txt, lv_action_txt);
  6     DBMS_OUTPUT.PUT_LINE('After   Module: ' || lv_module_txt ||
  7        CHR(9) || ' Action: ' || lv_action_txt);
  8  END;
  9  /
After   Module: PL/SQL BLock     Action: Testing DBMS_APPLICATION_INFO

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