Re: Sleep command in script
From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Wed, 17 Jan 2001 16:42:51 +0000
Message-ID: <3A65CB8B.A7981DE6_at_rdbms.freeserve.co.uk>
Date: Wed, 17 Jan 2001 16:42:51 +0000
Message-ID: <3A65CB8B.A7981DE6_at_rdbms.freeserve.co.uk>
Raj,
Try DBMS_LOCK.SLEEP(seconds IN NUMBER);
Chris
Raj Mandair wrote:
>
> I am trying to write a sql script that will maintain a connection to
> oracle in the background. The script will connect a user to oracle,
> maintain that connection for a period of time without doing anything
> and then exit.
>
> Is there a sleep command that can do this?
>
> Thank you in advance.
Received on Wed Jan 17 2001 - 17:42:51 CET