How to delete the package with the reserved word?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How to delete the package with the reserved word?

Hybrid View

  1. #1
    Join Date
    Jun 2001
    Location
    Hyderabad
    Posts
    18
    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.
    rams

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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


  3. #3
    Join Date
    Jun 2001
    Location
    Hyderabad
    Posts
    18
    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??
    rams

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Did you try this?
    Code:
    DROP PACKAGE "BODY";
    Sanjay

    [Edited by SANJAY_G on 07-27-2002 at 01:11 AM]

  5. #5
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width