| 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
Hello
u can recompile the procedure
ALTER PROCEDURE PROCEDURENAME RECOMPILE
Regards
Rambabu
-----Original Message-----
From: Kamalakannan, D (CAP, GCF) [SMTP:D.Kamalakannan_at_gecapital.com] 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 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 also send the HELP command for other information (like subscribing).
eJ8+IgwLAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEkAYAqAEAAAEAAAAQAAAAAwAAMAIAAAAL AA8OAAAAAAIB/w8BAAAARwAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAE9SQUNMRS1MQGZhdGNp dHkuY29tAFNNVFAAT1JBQ0xFLUxAZmF0Y2l0eS5jb20AAB4AAjABAAAABQAAAFNNVFAAAAAAHgAD MAEAAAAVAAAAT1JBQ0xFLUxAZmF0Y2l0eS5jb20AAAAAAwAVDAEAAAADAP4PBgAAAB4AATABAAAA FwAAACdPUkFDTEUtTEBmYXRjaXR5LmNvbScAAAIBCzABAAAAGgAAAFNNVFA6T1JBQ0xFLUxARkFU Q0lUWS5DT00AAAADAAA5AAAAAAsAQDoBAAAAHgD2XwEAAAAVAAAAT1JBQ0xFLUxAZmF0Y2l0eS5j b20AAAAAAgH3XwEAAABHAAAAAAAAAIErH6S+oxAZnW4A3QEPVAIAAAAAT1JBQ0xFLUxAZmF0Y2l0 eS5jb20AU01UUABPUkFDTEUtTEBmYXRjaXR5LmNvbQAAAwD9XwEAAAADAP9fAAAAAAIB9g8BAAAA BAAAAAAAAAKhUQEEgAEAIQAAAFJFOiBIb3cgdG8gZHJvcCB0aGVzZSBwcm9jZWR1cmVzAIwLAQWA AwAOAAAA0AcMABYAEAAkAAoABQA8AQEggAMADgAAANAHDAAWABAAIwAXAAUASAEBCYABACEAAABC N0YyNkFDMjI3RDhENDExQTU3NzAwOTAyNzM0MzM3RgD8BgEDkAYAyA0AACEAAAALAAIAAQAAAAsA IwAAAAAAAwAmAAAAAAALACkAAAAAAAMALgAAAAAAAwA2AAAAAABAADkAAE/wMAdswAEeAHAAAQAA ACEAAABSRTogSG93IHRvIGRyb3AgdGhlc2UgcHJvY2VkdXJlcwAAAAACAXEAAQAAABYAAAABwGwH MM7CavK42CcR1KV3AJAnNDN/AAAeAB4MAQAAAAUAAABTTVRQAAAAAB4AHwwBAAAAHgAAAFJhbWJh YnVfQWxsdXJpQGRhdGFtYXRpY3MuY29tAAAAAwAGEBcA9a8DAAcQzwYAAB4ACBABAAAAZQAAAEhF TExPVUNBTlJFQ09NUElMRVRIRVBST0NFRFVSRUFMVEVSUFJPQ0VEVVJFUFJPQ0VEVVJFTkFNRVJF Q09NUElMRVJFR0FSRFNSQU1CQUJVLS0tLS1PUklHSU5BTE1FU1NBR0UAAAAAAgEJEAEAAACVCgAA kQoAANwXAABMWkZ100Wf6QMACgByY3BnMTI1cjIMYGMxAzABBwtgbpEOEDAzMw8WZmUPkk8B9wKk A2MCAGNoCsBzhGV0AtFwcnEyAACSKgqhbm8SUCAwAdCFAdA2D6AwNTA0FCHzAdAUEDR9B20CgwBQ A9T7Ef8TC2IT4RRQE7IY9BTQrwcTAoACkQjmOwlvMBrf+mUOMDUcCh0hHN8d6Rv0/x4SHH8gTyAN H48dvxwPEGD8Mjgl2ibxJq8nuRv0J+K/Jk8qHyndKV8njytUOQ5QHy6kMAEoIzAAAoJzdHnqbAeQ aAngdAAAE1AD8FBkY3RsCrFcMlhhmGRqdTFwBRBnaAVCOxYyDAFjCcAyYAMwc258ZXgXMAewBbAA wAJzc7EAUHNiMhRQMWBhE/D0XGsJ4HALkDI/MqMIYOsykAuAZTGgdjlgAUAzm78MMDRkKAA3QASg C4BnJ/HpNOZiYRcQZAIgNaA1Rucx0DOQO5EgMTEzDlA2n/83rzi/AFE5/ACgNG48fz2G/zEkD8A+ jz+fQK8OUDnvQw/bRB89szMCghMQYzZgS6GTM5A9sHRpOZAgRAEQqGF1bAVAUArAYQnA4GFwaCBG AiE2JCVA6GZpLQ+QOAFAOTBQM+tHDzKjYgsgcglQUlIWoNlSUnc0JUEXAHAB0E1yfzO/Sp9Lpk/Q TpAFEAIwLUNPMANhOiBUb1ewUyh1YmoFkHRXsERh6HRlOjYkNk//UQ9SH/9TL1Q5McA9ow4hS6E6 tg5Qm1VvVn5SOYEXASBIPZH7BJA2JDdZb1p/W49cnTkPL12/D5BpcAjQYgqwdDj/SfoPVEYQX79g xmoAYdALULx5L09AXLALEWJFczYk/ygAYz9kT2VfXK9UT2tfbG/vbXVX0ld0WKk5b78zPwMwHWmz OXOfdK96oERvY/51B4ACMAXQTwAaAXjSeDD3eHBxUQGAblgwAGAJ8E2g730AAgE14F5SZQDwfQAx gJJwHoBcdgiQd2sLgP5ka0CAogTwB0AQYQFADgDvcSI9goIFAhBvBUIXIRLyDVjAbQtRWMAgQzpc 6lxXAG9O4W1PMAMQB5BNhLBNDeADYHNvAYAgrk8BIA3gf/BchmZFAMD1AxAuS3B0fdAXEHhwNSHt Z3J4AUB/AW4x0BrwiAQ9TjRjAyAS8wCABZBsdv9BoUbQDnA14IqSAZAAIIsi/4DxfUEBwYqRFuAP cAAARtDzDNABkCAuGhKKiA5Qi0L/TnB4wIu/jM+N3w/ARtAFgbePf5CPkZ9sa0BG0GyPP/uT/5UF KY4MJUCS35e/lPT4YiAoApGY34rTWVCWj/+bT5xfnW+LAGMQnrKLj6Af/6EvjgwoAJ6/pD+lT6Zf iwD/eACjP6jPqd+q5Ar5AzB4L+t5P3rNe2JQbAkACoUKhfggdSCBkAOgGvAFoIQg6YVhIHQx0CAX cH0ACYAFCHBls/xBTFRFUgFOkFJPQ0VEVVJiRbfoTkFNuHC4YEPgT01QSUy4cLP8CoV1YdBnCxFz uvaFIEswYr51s/yvpLBvsX8FQHu8v/+9w2dwraK+H78vCME08jWgIRLyYmtta6yzIF9HfYADEFih YX0txjJPP7JBC4AHQAXQB5BGUGdl/8YzvSuwBmL9byDB73C/cc//Zz9oT2lfam+zRMQ2V3MMgswg S4UgB0BhawBwxtCMbixOEKpQQ0FQ0+AAR0NGKSBbU02gVFA6RC7TKkDHYN+BkLWQAZCHoLVhXcff yOT/brvKH8svzD9yv7LMDCHERT8GYAIw0sQaItIm2bBhebfT4QWQhBBiBJBFYDLT4LcB0M+gTLA6 FBBOkE29JvfeWVfR311NTmEFILWxtUHfBSAIkAIwBCCGICDNoDFwkYZQUkFDueAtTOJf197hWCXf XldXsEjZkLXQ5G8g2wBvcLXSE3G2J/+7xq+swa/Cv90Ps1PAv+z/j+4Pw+TS4gqFSGkss/zGTzVg 5dJteSADUOWB/zUgFuAEILXgBAC2EgJghBDMIHf3ABbQIEn2oU3xbX0yaQIgCYAg4RAJAHe19L1U iTIgCsC1wXez5v3q6CCwQbXi4HABkUtB+sD59oFJJ4UwxrCAoD3R+oO9teFpBcAFoAIw5ZIus/z3 hNG2VD3wOrP8BQA9kIRh/wWxGvALUYagthi2Ew6QS0A/CoXhEMax+0kxIAqFZGJVf6BfzXFwzYAu BtFfec2iKCf4IIUhsEEAcjG8JykF1n8BBdYADzIBLQ0DPDIEL/tnMV9zeb8V0KpQDij8UPbSE4Ag DpHdS4B5hTDl4QM9Kf+G8M//8d+/XQZfB28IeRJfE2+/XfkJLyBCg0BPIOXh/JGFMPv60gTwdtNQ NRH9YkmjbTBhEBBvLiBXMdDsoHnfzXD+8bWHhTAfQSezwP3QP4OQDQWVUK1ggpD5UGNr1QkQcupA ch7QQs2A9gD/AoAdUbWAAoD88K8gbTDT4Pv4ILUBJ4NQ/sD8kQYxzdH/hGHqg/tPAnIowE3AHeS1 Wv5tHtANBR7z7uD2IOoytZD/PdH8khApD9MDPk3ADQW7gP9N8fiBtdODILPBGTA90SIT2/S+5nAt z6BGcDRXsCIT/eXQY30QIiD5AViwtTK2gOJzTeJTUUzmAM3yAQDvLxrPklewh3B4IxB9IOXQ/4Bg 7KAxcgKA/EA9MIagJuD/JuD/jR7z+CDu4fkBtWQ9wv34IGeDQfbzIhQury+wRiD/2/AwFfxAtnE9 wrVGWLD40R4vArAdkzvz5dJUQk30Uy638jI5fHsgV7Ahh/+tYFjAGWD5AffBtbIpQCnD/+oQIcP3 YFhCPUgyljYf+QH/KXv7uoNQLNMtPy5PL1kzkf9XITAwxtIwNNbArWDT4A1ACmd9I3NXsFs0ODgE Ml3T4Fs5OTM2zDc1S4N7IDI4TCBZQLdLkA0FS8A3TBBLYDBLkr9OG7of+jS1EMUg/VNC/DDng1C7 ZfS2TUTiRsYwCce/JPD9ImIgtcTl4IaBacbhc+Zm4DBBUVew7yAV0DqoLy93VnAuAoBhieDWcday Up9BzYBoAoBLIH/TL9Q3F88Y3xnvv/O0wEn4TkVUdzHVT9ZYWo9bn2tcr7/6RjEhQ9Zw9iBO24OQ +yByIfDfAHKAoIagV/xAZcFTAShMsDjUsDXAMzgtNTA1BBBVoa5YSyBmPA0FU7URRICw+zgQ0+BD HaF/ca0wlVBqJe1TAVDoIM2gY/gQSVODkGf6wDCgxyEgL31xN5RM/+Yhu8bGM23vbv9wD3Da+gbj 6hC4YE1PVrhwH0HcMP/N0OXw9kC1cPbkh3I3suYS/9Pg/TD2gbUR5rDFoviBxzMvDQXqAEsgbOJH toB1QH+J4IogZIHWsqpQYZCEYUX6WOaAVBAQgGCzwDey5eH+J3cWCID9UwT3/JJ19RxQuE9EWdPg BPCKMHWtYD8hUc2i/vOwMTexSyBVTuhTVULmXigCgfySxtDvRkH14nQ5HzN3I3Hp8g1wf7UxIsDO AB3Qc4IRwLTAWesfUYdweSD2bB6wdPT8kvBIRUxQH3KHcPaBacG/5dAkgwTwacGAkDzTKM2glmsq Ieggc6xQaWI3sT8RwK7gxLb2csWYvSZ9AAOKgIqwAAAAAwAQEAAAAAADABEQAQAAAAMAgBD///// QAAHMOCzlRQHbMABQAAIMOCzlRQHbMABCwAAgAggBgAAAAAAwAAAAAAAAEYAAAAAA4UAAAAAAAAD AAKACCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAMABYAIIAYAAAAAAMAAAAAAAABGAAAAAFKF AAC3DQAAHgAlgAggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEAAAAEAAAAOC4wAAMAJoAIIAYAAAAA AMAAAAAAAABGAAAAAAGFAAAAAAAACwAvgAggBgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADADCA CCAGAAAAAADAAAAAAAAARgAAAAARhQAAAAAAAAMAMoAIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAA AAAAHgBBgAggBgAAAAAAwAAAAAAAAEYAAAAANoUAAAEAAAABAAAAAAAAAB4AQoAIIAYAAAAAAMAA AAAAAABGAAAAADeFAAABAAAAAQAAAAAAAAAeAEOACCAGAAAAAADAAAAAAAAARgAAAAA4hQAAAQAA Received on Fri Dec 22 2000 - 05:06:10 CST
 |
 |