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 functionality

743475Dec 29 2009 — edited Jan 1 2010

Hi,

I'm not able to use a DBMS_LOCK.SLEEP in a procedure. It says it has to be declared. But in case I use it as a separate Query it works. Please send me possible reasons.

regards,
Srivathan, T.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 29 2010

Added on Dec 29 2009

13 comments

2,320 views