-
I have a package name BODY in my schema. I got error
when I create the BODY as a package name and got message"Package created with errors". How to delete the package from the scheme as it is SQL Reserve word. I tried with DROP PACKAGE SCHEMA.BODY, DROP PACKAGE "SCHEMA.BODY". Can we drop this by using object id ??? Any suggestions...
Thanks in Advance.
-
Ramesh,
Are you creating PACKAGE or PACKAGE BODY ??
You can't create a package named BODY unless you had specified it in double quotes..
To see the list of stored procedure / functions and package bodies, use this.
Code:
select distinct name, type from user_source;
Look for your object and type and then drop accordingly.
HTH
Sanjay
-
Thanks Sanjay
I checked in user_source view. result is
sql> select distinct name,type from user_source;
NAME TYPE
------------------------------ ------------
BODY PACKAGE
SP_LOAD PACKAGE
When I tried to Drop the package I am getting internal errors like "The following errors are in the ALERT file : ORA-00600: internal error code, arguments: [15264], [], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [15264], [], [], [], [], [], [], []".
Any other suggestions??
-
Did you try this?
Code:
DROP PACKAGE "BODY";
Sanjay
[Edited by SANJAY_G on 07-27-2002 at 01:11 AM]
-
Hi,
The [15264] error occurs when we are attempting to lock an object in the row cache and find that the object does not exist. So it would make sense you are getting that error if the above is the case.
Every ORA-600 error creates a dump file in the user_dump_dest directory.
apperantly there is a bug in MetaLink on this issue
------------------------------------------------------------
Problem statement:
DROP PACKAGE ORA-600 [15264],DROP USER ORA-600 [15013],OBJECT_TYPE='NEXT OBJECT'
--------------------------------------------------------------------------------
PROBLEM:
Run "create package .body IS ... END;" will create an object named 'BODY'
with object_type= 'NEXT OBJECT' and user cannot drop object BODY or schema anymore.
drop package .body;
will give you ORA-00600 [15264]
drop user cascade;
will give you ORA-00600 [15013]
User schema is corrupted with orphan package left in data dictionary .
select object_name, object_type from user_objects;
OBJECT_NAME OBJECT_TYPE
------------------------------ ------------------
BODY PACKAGE
BODY NEXT OBJECT <-----
select obj#, owner#, name , type# from obj$ where name = 'BODY';
where name = 'BODY'
and owner# = ( select user_id from dba_users where username = '');
OBJ# OWNER# NAME TYPE#
---------- ---------- ------------------------------ ----------
2999 25 BODY 9
0 25 BODY 0 <---
'BODY' object with 'NEXT OBJECT' type always have object# = 0
and type# = 0
-------------------------------------------------------------
cheers,
R.