dbms_application_info.set_client_info : dbms_application_info « System Packages « Oracle PL / SQL






dbms_application_info.set_client_info

 


SQL>
SQL> create table myTable as select rownum id, a.* from all_objects a where rownum < 20;

Table created.

SQL>
SQL>
SQL> declare
  2      myLong   long;
  3      myNumber number;
  4  begin
  5      dbms_alert.register( 'WAITING' );
  6      for i in 1 .. 999 loop
  7          dbms_application_info.set_client_info( i );
  8          dbms_alert.waitone( 'WAITING', myLong, myNumber, 0 );
  9          exit when myNumber = 0;
 10          for x in ( select * from myTable order by 1, 2, 3, 4 )
 11          loop
 12              null;
 13          end loop;
 14      end loop;
 15  end;
 16  /

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL> drop table myTable;

Table dropped.

   
  








Related examples in the same category

1.Demonstrates DBMS_APPLICATION_INFO and its two procedures.
2.Execute the DBMS_APPLICATION_INFO package.
3.Use DBMS_APPLICATION_INFO and USERENV() in building a publish-and-subscribe implementation.