Re: how to make PL/SQL wait for 60 seconds

From: Paul Vallee <dbalist_at_pythian.com>
Date: Fri, 20 Jul 2001 06:23:21 -0700
Message-ID: <F001.0034FBA4.20010720053648@fatcity.com>

Hi John,

SQL> desc dbms_lock
[snip]
PROCEDURE SLEEP

 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 SECONDS                        NUMBER                  IN

Hope this helps,
Paul

Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, July 20, 2001 8:46 AM

I want to put a sleep or wait in my PL/SQL function

Is there an easy way to do this?

John
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: John Dunn
INET: john.dunn_at_sefas.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Paul Vallee
INET: dbalist_at_pythian.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------