Hi
iam a new entrant to oracle I have a small solution See if that is OK In ur PL/SQL block u need to issue a SQL*PLUS command (say Set Pause On) This is set only when the countof record reaches every 20 records . This can be done using DBMS_SQL package. wherein u have dynamic queries being generated , I believe .See if this is Ok . If u have any solution do post it back.

Bye