Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    87

    Smile Unanswered: query to display package body??

    hi all,

    I wanna know the query ,that will display package body, which has been created already.

    Anybody can help me??
    thanx.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: query to display package body??

    select text
    from user_source
    where type = 'PACKAGE BODY'
    and name = 'MYPACKAGENAME'
    order by line;

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Here's a script that will build a file containing your package...
    At the end is a "SPOOL" statement... Change the directory structure
    to match your environment and you will have a script that will
    rebuild your package ....

    It will ask you for owner, package_name ...

    HTH

    Gregg
    Attached Files Attached Files

Posting Permissions

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