Skip to Main Content

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!

DBMS_LOCK.Sleep() considered dangerous?

628567Aug 8 2008 — edited Aug 11 2008
I have some PL/SQL that needs to runs continuously, pulling new entries from a table as they are added. I'd use a trigger for this, but need to invoke a synchronous Web service and don't want table inserts to be blocked waiting for the trigger to complete.

So instead my PL/SQL runs in a polling loop which needs to go to sleep for a few seconds whenever it discovers it has run out of things to do.

Based on the documentation, DBMS_LOCK.Sleep is exactly what I need, but one of my colleagues is adamant that it is unnecessary and even dangerous to use it in this situation - partly because of security vulnerabilities.

Can anyone confirm or contradict this?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 8 2008
Added on Aug 8 2008
4 comments
1,595 views