While deploying/Compiling PL/SQL package or spec no response/hangs on current session

Issue:

While deploying/Compiling PL/SQL package or spec no response/hangs on current session

If you find the session details for your session the event will be as ” Library Cache Load Lock”

SQL> alter PACKAGE “APPS”.XXXS_XXXR compile body;
^C
Warning: Package Body altered with compilation errors.

We need to interrupt the session to get out from this session.

Cause:

This is mainly because of the package body which is in use with some other on going programs

we cannot find this as blocking session

We need to find by finding sql_text from v$sql related to package body

Solution:

Just wait the process to complete or kill the process and try to compile the body again

SQL> alter PACKAGE “APPS”.XXXS_XXXR compile body;

Package body altered.

SQL> show errors;
No errors.

  • January 3, 2018 | 19 views
  • Comments