Home » Other » General » Delay On Oracle
Delay On Oracle [message #104751] Mon, 24 January 2005 17:28 Go to next message
Salvador
Messages: 3
Registered: January 2005
Junior Member
Hi all, i am searching for a way to generates a delay times, i.e. if a condition is meet (record locked) i want to wait for instance 20 seconds and then try again, did somebody knows how to use this feature on pl sql? how to made the delay??

Thanks in advance,
Salvador

Report message to a moderator

Re: Delay On Oracle [message #104759 is a reply to message #104751] Wed, 26 January 2005 01:08 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Consider using DBMS_LOCK.SLEEP()

Best regards.

Frank

Report message to a moderator

Re: Delay On Oracle [message #104760 is a reply to message #104759] Wed, 26 January 2005 07:11 Go to previous message
Salvador
Messages: 3
Registered: January 2005
Junior Member
Thanks it works...

Report message to a moderator

Previous Topic: Huge Data fail using odbc
Next Topic: Just need to be familiar with Oracle
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 02:16:09 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.