SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sleep Function in PL/SQL

ShapsFeb 28 2012 — edited Feb 28 2012

Hi Guys,

I am creating a procedure which will check for the fileld in the database and if it returns NULL should go to sleep for 15 minutes and then will again check for the field. I am planning to use DBMS_LOCK.SLEEP function. Please can you suggest if the same is fine or advise if in case there is any other specific function which I require to use as I have read that the mentioned function is not accurate in calculating the SLEEP time.

[http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:6019886867656]

Best Regards,
Shaz

This post has been answered by Billy Verreynne on Feb 28 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 27 2012

Added on Feb 28 2012

13 comments

191,285 views