Home » SQL & PL/SQL » SQL & PL/SQL » help with creating a delay in stored procedures
help with creating a delay in stored procedures [message #253854] Wed, 25 July 2007 02:14 Go to next message
bloodaxe
Messages: 1
Registered: July 2007
Location: Philippines
Junior Member

Hello all

I have tried DBMS_LOCK.SLEEP(); in a stored procredure but i don't think this works in a stored procedure. I would get a "PLS-00201: identifier 'DBMS_LOCK' must be declared" error.

Is there any way I can create a delay in a stored procedure? I would like to create a 10 second delay before executing the next command. Is it possible?
Re: help with creating a delay in stored procedures [message #253869 is a reply to message #253854] Wed, 25 July 2007 02:49 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You must have been DIRECTLY granted the execute privilege on it to be able to use it.

Regards
Michel
Previous Topic: Recursive Cursor
Next Topic: table type
Goto Forum:
  


Current Time: Wed Dec 07 18:38:19 CST 2016

Total time taken to generate the page: 0.05261 seconds