Error (12,4): PLS-00201: identifier 'DBMS_LOCK' must be declared is seen for procedure OBLICORE.PRC_LOCK_RESOURCE@01
search cancel

Error (12,4): PLS-00201: identifier 'DBMS_LOCK' must be declared is seen for procedure OBLICORE.PRC_LOCK_RESOURCE@01

book

Article ID: 251340

calendar_today

Updated On:

Products

CA Business Service Insight

Issue/Introduction

Getting errors for two procedures prc_lock_resource and prc_unlock_resource on the database as below:

Environment

Release : 8.35

Component :

Resolution

The given error is permission-related, specifically GRANT on DBMS_LOCK. 

After providing the required rights for DBMS_LOCK in Oracle it is working fine.