Viewing a Procedure
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Viewing a Procedure

  1. #1
    Join Date
    Nov 2001
    Location
    Nottingham
    Posts
    20

    Viewing a Procedure

    Hi,

    I was wondering if anyone could tell me how i can get a copy of a procedure i.e.
    I want a copy of the procedure STATSPACK.STAT_CHANGES
    I have queried ALL_SOURCE but cant work out how to specifically select the STAT_CHANGES part so I can spool and save it to a file.

    Any advice much appreciated....

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    how about try dba_source

  3. #3
    Join Date
    Apr 2003
    Posts
    353
    The source of the mentioned procedure will be available at the
    %oracle_home/rdbms/admin/spcpkg.sql

    Using OEM/TOAD are some of the ways of extracting the source

  4. #4
    Join Date
    Nov 2001
    Location
    Nottingham
    Posts
    20
    Hi Thanks for info
    I found the source in %oracle_home/rdbms/admin/spcpkg.sql

    Thanks again

    Shandy

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