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
vkrmhj
Messages: 9
Registered: May 2007
Junior Member
Hi All,
Is there any alternate to dbms_lock.sleep() for getting some delay in a program.
Regards,
Vikram
[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
Maaher
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.

MHE
Previous Topic: query required...
Next Topic: ORA-00937 - Count() problem
Goto Forum:
  


Current Time: Sun Dec 11 03:54:02 CST 2016

Total time taken to generate the page: 0.10708 seconds