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?

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You must have been DIRECTLY granted the execute privilege on it to be able to use it.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 03 17:43:13 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.