package compilation hangs

From: <jaysingh1_at_optonline.net>
Date: Tue, 31 Aug 2004 15:49:14 -0400
Message-id: <65b290659864.65986465b290@optonline.net>

Hi All,

The package BODY status became invalid because of the object modification(another package) refered in the package body.

Now we are trying to compile the package and it hangs.

Checked DBA_DDL_LOCKS
select owner,session_id,mode_held from dba_ddl_locks where name='SEARCH_PKG';

OWNER,SESSION_ID,MODE_HELD
----- ---------- ----------

REPORTS,667,Share
PUBLIC,667,Share
ATG56,667,Share
REPORTS,667,None
REPORTS,968,Exclusive

If I kill session_id 968, something else appears here. I did this exercise 4 times. What could be wrong here.

select * from gv$access where object='SEARCH_PKG' is returning more than 50 records.

Could someone shed some light on this?

Thanks
Jay

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Tue Aug 31 2004 - 14:45:40 CDT