Skip to Main Content

Oracle Database Discussions

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!

PLS-00201: identifier 'DBMS_LOCK' must be declared

user7202581Apr 15 2014 — edited Apr 16 2014

Hi,

Need to run dbms_lock.sleep( e_sleep_seconds ) from a particular user hcsops_prod.

I get an error dbms_lock.sleep( e_sleep_seconds );

Please advise.

Regards,

Narayan

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 14 2014
Added on Apr 15 2014
5 comments
6,474 views