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

The following code would sleep for 60 seconds.

declare
val number;
begin
val := 60;
DBMS_LOCK.sleep(t);
end;

>>> john.dunn_at_sefas.co.uk 07/20/01 08:46AM >>>
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).

------------------------------------------------------------
This electronic mail (e-mail) and any files transmitted with
it are confidential and are intended solely for the use of
the individual or entity to whom they are addressed.
Personal views and opinions expressed in this communication
are those of the originator and may not necessarily reflect
those of O'Brien & Gere and O'Brien & Gere shall not be
liable for any damage caused by or resulting from any such
material. If you are NOT the original recipient or the person
responsible for delivering the e-mail to the intended
recipient, be advised that you have received this e-mail
in error, and that any use, dissemination, forwarding,
printing, or copying of this e-mail is strictly prohibited.
If you received this e-mail in error or any objectionable
material, please delete it and immediately notify
"Postmaster_at_Obg.Com"

It is O'Brien & Gere's policy to respect the privacy of its
employees and third parties communicating with O'Brien & Gere
via e-mail. However, the O'Brien & Gere e-mail system may not
be used for any illegal purposes or for the transmission of
material that is libelous, vulgar, obscene, invasive of
another's privacy, unlawful, harassing, abusive, threatening,
harmful, or otherwise objectionable [objectionable material].
This includes anything that may infringe on the intellectual
property or rights of another.  O'Brien & Gere may monitor
communications but is under no obligation to do so. O'Brien &
Gere may, in our absolute discretion, remove, block or filter
any material if in our view it is objectionable material or
otherwise inappropriate.


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
  INET: BeilstWH_at_obg.com

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).