Re: How to set time delay in Oracle store procedure?

From: Thomas Kyte <tkyte_at_oracle.com>
Date: 9 Apr 2002 13:08:11 -0700
Message-ID: <a8vhnb02n1l@drn.newsguy.com>

In article <8e67e5c0.0204091048.52bbe209_at_posting.google.com>, zhang41_at_hotmail.com says...
>
>I am trying to set 1 minute delay in a store procedure. Does anybody
>know how to implement that?(by using some oracle built in functions).

dbms_lock.sleep(60)

read http://osi.oracle.com/~tkyte/Misc/RolesAndProcedures.html

when you get PLS-00201: identifier 'DBMS_LOCK' must be declared

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Tue Apr 09 2002 - 15:08:11 CDT