use dbms_lock package.
First test whether you have access for using dbms_lock package or not.
If you are not having access to it, first grant privileges to the user for
dbms_lock package and use the following command.
DBMS_LOCK.SLEEP(60);
-Padmaja.
"Kiben C" <zhang41_at_hotmail.com> wrote in message
news:8e67e5c0.0204091046.5063bbcc_at_posting.google.com...
> 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).
Received on Fri Apr 12 2002 - 16:17:41 CDT
