Re: Pausing inside a cursor

In article <7av44t$ij$1_at_nnrp1.dejanews.com>,

        jrsmith_at_netwave.net writes:
>
> How do I get this script to pause inside the loop regardless of
> linecount? When I put in:
>
> PAUSE Strike return...;
>
> It rags that it's looking for a token or an assignment operator.
> When I remove the pause, the app runs cleanly but scrolls by faster
> than the user can appreciate.

You can't. PL/SQL is, just like SQL, not built for interactive use. You submit a block of code to the server, you get back some data -- that's all that ever happens.

If you want the user to be able to view the output, you could make use of a spool file and a program like 'more' or 'less' to show the spool file to the user, like this (assuming you are doing this with sqlplus):

spool output
<insert code here>
spool off
host more output.lst

Remco
--
rd31-144: 8:05pm up 18:54, 5 users, load average: 1.05, 1.09, 1.06 Received on Wed Feb 24 1999 - 13:14:03 CST