104/13 PLS-00201: identifier 'DBMS_LOCK' must be declared

while working on autonomous database after import of soe schema, I got following error while doing compilations of package owned by soe schema:


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


Last Successful login time: Wed Feb 10 2021 20:56:22 +05:30


Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.5.0.0.0


SQL> ALTER PACKAGE SOE.ORDERENTRY COMPILE BODY;


Warning: Package Body altered with compilation errors.


SQL> sho error

Errors for PACKAGE BODY SOE.ORDERENTRY:


LINE/COL ERROR

-------- -----------------------------------------------------------------

104/13   PL/SQL: Statement ignored

104/13   PLS-00201: identifier 'DBMS_LOCK' must be declared

107/13   PL/SQL: Statement ignored

107/13   PLS-00201: identifier 'DBMS_LOCK' must be declared

SQL> GRANT execute ON DBMS_LOCK TO soe;


Grant succeeded.


SQL> ALTER PACKAGE SOE.ORDERENTRY COMPILE BODY;


Package body altered.


SQL>

Comments

Post a Comment

Popular posts from this blog

ORA-46697: Keystore password required - create pluggable database pdb1clone from pdb1

  select con_id,name,open_mode from v$pdbs;     CON_ID NAME     OPEN_MODE ---------- -------------------------------------------------------------------------------------------------------------------------------- ---------- 2 PDB$SEED     READ ONLY 3 PDB1     READ WRITE SQL> create pluggable database pdb1clone from pdb1; create pluggable database pdb1clone from pdb1 * ERROR at line 1: ORA-46697: Keystore password required. Solution: If  TDE is configured, you have to supply the keystore password  SQL> CREATE PLUGGABLE DATABASE PDB1clone FROM PDB1  KEYSTORE IDENTIFIED BY password;
Read more

OAM 11.1.2.3 - Bad Oracle Access Manager Request Error After Applying OAM Patch 27373151 + Webgate Patch 27393427 BP 11.1.2.3.180717

After Applying OAM Patch 27373151 + Webgate Patch 27393427 BP 11.1.2.3.180717, when accessing the http resource then it was giving Bad Oracle Access Manager Like when accessing "http://hostname.domain:7779/index.html" we get following message in the logfile "diagnostics/logs/OHS/ohs1/oblog.log" 2018/10/26@15:29:46.68427       1890    1950    WEB     ERROR   0x0000151F      /ade/aime_ngamac_748106/ngamac/src/palantir/commonlib/src/apache2_req_info.cpp:294     ecid^005UIDZfNp87U8ups^h8iX0000SX00001w  rid^0   "WebGate Error Report"  Message^Unable to process the request due to unexpected error.  ReqReq^GET /public/index.html HTTP/1.1  ReqProto^HTTP/1.1       ReqHost^bdrvl-pd-oid01  ReqStatLine^    ReqStatus^200   ReqRawUri^/public/index.html    ReqUri^/public/index.html       ReqFilename^...
Read more