Home » SQL & PL/SQL » SQL & PL/SQL » alternative to dbms_lock.sleep() (oracle 9i)
alternative to dbms_lock.sleep() [message #275859] Tue, 23 October 2007 01:27 Go to next message
Messages: 9
Registered: May 2007
Junior Member
Hi All,
Is there any alternate to dbms_lock.sleep() for getting some delay in a program.
[EDITED by LF: a typo in topic title; was 'dbma_lock', changed to 'dbms_lock']

[Updated on: Tue, 23 October 2007 01:35] by Moderator

Report message to a moderator

Re: alternative to dbma_lock.sleep() [message #275861 is a reply to message #275859] Tue, 23 October 2007 01:32 Go to previous message
Messages: 7062
Registered: December 2001
Senior Member
Not that I can think of, nor can I think of any reason why anyone would want that. I'd program the delay - if really really necessary - in the front end, not the database side. Be very careful when you want that kind of anti-performance. Most people want to get as much done in as little time as possible. Wink

You might have a chance if you look at a Java Stored Procedure though.

Previous Topic: ORA-00937 - Count() problem
Next Topic: Execute Plan About My Sqls
Goto Forum:

Current Time: Sun Aug 20 14:22:24 CDT 2017

Total time taken to generate the page: 0.05251 seconds