Re: Sleep function in PL/SQL

maro_at_gbg.ifsab.se (Magnus Rosenquist) wrote:
>Hi !
>
> I was just wondering if there exist a function similar to the unix
>shellscript command 'sleep(10)' in PL/SQL, where '10' would be the
>number of seconds the process should wait before proceeding.
>
> If anyone knows of an existing function, I would be thankful for a
>tip. Otherwise I will probably write one myself, and post it here.
>
>Thanks for your time !
>
>/Magnus

Hi there,

I came across a function which addresses your requirement. It is either

DBMS_SYSTEM.sleep(10)

I do not know the exact procedure name,but I can give you a hint.

go to $ORACLE_HOME/rdbms/admin directory in your server and issue the following grep command (I assume that you are using an UNIX server)

grep -i 'sleep' *.sql

This will tell you the exact file name and the syntax.

Hope this partial info helps you,

Regards

N.Prabhakar
Socgen Crosby Securities
Singapore Received on Wed Nov 13 1996 - 00:00:00 CET