Sometimes it’s necessary to show the output of the PL/SQL script. Usually the dbms_output package is used:

SET serveroutput ON DECLARE  i NUMBER ; BEGIN  i:=0 ;  WHILE i< 100000 LOOP   i:=i+1 ;   dbms_output.put_line(’This is just test line #’ || TO_CHAR(i) ) ;  END LOOP ; END; /

After several thousands lines the […]