| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to drop these procedures
Hi!
quite interesting to try this problem. I tried dropping the procedure, dropped without any probs. After dropping the procedure, synonym can be dropped.
Regards
Raji
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of
Kamalakannan, D (CAP, GCF)
Sent: Friday, December 22, 2000 3:30 PM
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 Liststo: 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 also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.211 / Virus Database: 100 - Release Date: 11/14/00
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Received on Fri Dec 22 2000 - 05:44:15 CST
 |
 |