Oracle Database Discussions

Hi

11.2.0.4.0

12.1.0.2.0

I was wondering, how can I make use of PAUSE while executing a procedure or autonomous pl/sql block.

For example.

set serveroutput on size unlimited;
set verify on;
set pages 10;
set pause "Press ENTER to continue.."
declare
...................
.......... some query, which output is printed by dbms_output package
end;
/

But this does not trigger this "Press ENTER to continue..", even when there are printed more than 10 rows (pagesize = 10)

Regards

Raul