dbms_lock.sleep must be declared error ( Packages Invalid ) solution

Hello, n the Oracle PL/SQL, I want to test the sleep function. I am using PHM_DEV schema. but it gives me error : dbms_lock.sleep must be declared error

Schema name : PHM_DEV

Cause :The Oracle schema  does not have access to the DBMS_LOCK package.

solutions : connect to database ass sysdba

grant execute on SYS.DBMS_LOCK to schema_name;

[oracle@jery ~]$ sqlplus / as sysdba

SQL*Plus: Release Production on Wed Mar 14 15:07:21 2018

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> grant execute on SYS.DBMS_LOCK to PPM_DEV;

Grant succeeded.


all of the packages were compiled. have a good day.


Hits: 6

Leave a Reply

Your email address will not be published. Required fields are marked *