dbms_application_info.set_client_info and dbms_application_info.set_action : dbms_application_info « System Packages « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Packages
  3. dbms_application_info
SQL>
SQL> declare
  2      l_owner varchar2(30) default 'SYS';
  3      l_cnt   number default 0;
  4  begin
  5      dbms_application_info.set_client_info( 'owner='||l_owner );
  6
  7      for x in ( select * from all_objects where owner = l_owner )
  8      loop
  9          l_cnt := l_cnt+1;
 10          dbms_application_info.set_action( 'processing row ' || l_cnt );
 11      end loop;
 12  end;
 13  /

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