Re: Pausing inside a cursor

From: Christoph Glanz <christoph.glanz_at_lhsystems.com>
Date: 26 Feb 1999 09:15:13 GMT
Message-ID: <slrn7dcph4.81.christoph.glanz@wnt-hamlsy0143.lrs.ham.dlh.de>

Hi, Jim,

On Tue, 23 Feb 1999 20:47:28 GMT, jrsmith_at_netwave.net <jrsmith_at_netwave.net> wrote:
[...]
>
>DECLARE
> CURSOR c IS SELECT...;
> v c%ROWTYPE;
>BEGIN
> OPEN...
> LOOP
> FETCH... etc...
> EXIT WHEN...
> DBMS_OUTPUT.PUT_LINE(zzyzz)...
> ...
> [ and I want to prompt for return here regardless of page size ]
> --DO OTHER THINGS...
> ...
> ...
> END LOOP;
> CLOSE...
>END;
>/
>bail
>
>How do I get this script to pause inside the loop regardless of
>linecount? When I put in:

You can use DMBS_LOCK.SLEEP(n) to pause for n seconds.

Regards
Christoph Glanz

--

Christoph Glanz                Tel: +49-40-5070-7675
Lufthansa Systems AS GmbH      Fax: +49-40-5070-7880
Schuetzenwall 1                Internet: http://www.lhsystemsas.de

D - 22844 Norderstedt Received on Fri Feb 26 1999 - 03:15:13 CST