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 […]