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.