Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Location
    California, USA
    Posts
    7

    Question Unanswered: Examining Stored Procedures

    There's probably an obvious answer to this question...

    How do you view the code for a stored procedure within SQL*Plus?
    I can see the code by going through DBAStudio, but I want to learn how to do it in a command-line. Do I look somewhere in the data dictionary?

  2. #2
    Join Date
    Jul 2003
    Location
    Hong Kong
    Posts
    56

    Re: Examining Stored Procedures

    Try the below:

    Code:
    SELECT text
    FROM user_source
    WHERE name = 'procedure_name'
    ORDER BY line;
    Last edited by shev; 08-27-03 at 03:59.
    Cheers,
    Shev

  3. #3
    Join Date
    Aug 2003
    Location
    California, USA
    Posts
    7
    Excellent!
    Thanks shev.

Posting Permissions

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