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 188.8.131.52.0 Production on Wed Mar 14 15:07:21 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Oracle Database 11g Enterprise Edition Release 184.108.40.206.0 – 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;
all of the packages were compiled. have a good day.