Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441

    Unanswered: Stored procedure listing

    Hi guys,

    I need to list the source of a stored procedure from SQL*Plus command line...I can't for the life of me remeber how this is done - please help, google has been of no use today!

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    dba_source is a place to look ... Here's a script I used to build me a script file of the actual source code for a procedure ...

    At the end of this listing, you change the directory structure to match your environment ...

    pass is the name of the procedure and the procedure owner and it does the rest ...

    HTH
    Gregg
    Attached Files Attached Files

  3. #3
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441
    Thanks!

Posting Permissions

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