RE: How to drop these procedures

How about recreating the procedures without the circluar references?

eg
create or replace procedure proc1 as
begin
/* delete the reference to proc2 */

dbms_output.put_line('I am in Proc1');
end;
/

procedure proc2 as
begin
/* delete the reference to proc1_syn; */
dbms_output.put_line('I am in Proc1');
end;
/

then drop procedure proc1/proc2?

-----Original Message-----
From: Kamalakannan, D (CAP, GCF) [mailto:D.Kamalakannan_at_gecapital.com] Sent: 22 December 2000 10:00
To: Multiple recipients of list ORACLE-L Subject: FW: How to drop these procedures         

Hi,

One of my friend has this problem which I have mentioned below,

There are two
procedures in the database and I'm giving here their contents.

Procedure 1:

create or replace procedure proc1 as
begin
proc2;
dbms_output.put_line('I am in Proc1');
end;

Procedure 2:

procedure proc2 as
begin
proc1_syn; ( proc1_syn is the synonym of procedure proc1). dbms_output.put_line('I am in Proc1');
end;

Both of them are invalid and rightly so. When you compile them you'll get a deadlock error. But more importantly, I can't either delete these procedures or edit and recompile them.
When try dropping the synonym of the procedure proc1 it gave me the following error,

ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded.

When I tried compiling I got this error.

ORA-04045: errors during recompilation/revalidation of TBMS.PROC2 ORA-04020: deadlock detected while trying to lock object TBMS.PROC1

When I tried dropping the procedures it gave me the following error,

ORA-00600: internal error code, arguments: [4882], [9936752], [20285216], [9775880], [], [], [], []

Thanks and Best Regards,
MDM

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kamalakannan, D (CAP, GCF)
  INET: D.Kamalakannan_at_gecapital.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may