dictionary table to check the package info
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: dictionary table to check the package info

  1. #1
    Join Date
    May 2002
    Posts
    163

    dictionary table to check the package info

    Hi,

    Which dictionary table I can refer to check the package information? User "XYZ" created a PL/Sql package and I would like to see the body of that package. How to get the body of that package from a dictionary table?

    Thanks
    Nwcomer
    Student

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Use USER_SOURCE or DBA_SOURCE

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

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