Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Unanswered: Stored Procedure

    How can I display the contents of an existing stored procedure in my Oracle database?
    What are the sql statements to show me the procedure?

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Here's a script to rebuild a stored procedure from the database.

    It will spool to an output file that IS the script to rebuild the
    procedure. Change the name and location of the spool file
    at the end of this script to match your environment.

    HTH
    Gregg
    Attached Files Attached Files

  3. #3
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311
    hi,

    u can use the all-source view to view your procedures or extract them from the database.
    Also u can use a third party tool like TOAD (www.toadsoft.com) to view, extract and alter them.

    Hope this helps
    Edwin van Hattem
    OCP DBA / System analyst

  4. #4
    Join Date
    Oct 2003
    Posts
    2
    Hi guys,

    thanks for the sql script, it works fine and does the job.

Posting Permissions

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