Can't see package body
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Can't see package body

  1. #1
    Join Date
    Jul 2002
    Posts
    2
    My DBA wants to allow me to select the information from the all_source on the production server (8.0.5), but I could only see package specification. She does not want to give me DBA privilege.

    I need this ability to solve defect without having to hunt down the meeting she is in and have her run the script for me.

    Any hints would be welcomed.

    Thanks.

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    When you can crack the package body, you will be on to something really big. Oracle wraps the package body - you don't get to see the code underneath. You can view the spb file, and some of it will be readable, but not enough to be of any value. Why can't she give you the uncompiled package body script? This has nothing to do with DBA privileges.

  3. #3
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Using the ALL_SOURCE view you can only see source you have been granted privilege on (procedures, functions and package specifications). Since no privileges are granted on the package body you will never be able to see package body source from other users via this view. What you need is for your DBA to grant you SELECT on the DBA_SOURCE view. This will allow you to see all the source for all the users. Obviously, if you are looking at Oracle supplied packages all you will see is the wrapped source.

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  4. #4
    Join Date
    Jul 2009
    Posts
    1
    Well I have a similar problem. I am using a database user that is shared by all of us here. However, they're all on XP-PC using Toad as client using ODBC and oracle client. I am running on a Mac-intel 10.5.7 using aqua data studio or JDeveloper or SQL Developer, tried them all. I use JDBC to connect. Have downloaded the latest from oracle site. I just can't see the package bodies. Only the specs and then again, even not all of them! Really strange. Our DBA has looked into it and he is as puzzled as I am. I am using a user who has full read access. Does anyone have a bright idea?


    Thanks guys.
    Kind regards
    Lorenzo

  5. #5
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Is your DBA seeing the package body in dba_objects?
    How about dba_source view?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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