Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2004
    Location
    Buenos Aires, Argentina
    Posts
    28

    Unanswered: Stored Procedure

    Hi guys,
    I have a question similar to the last one I made a few weeks ago, now related to Stored Procedures.
    How can I see the code of one Stored Procedure? I have the name, but I can't figure out where to see the code (in my last post, the issue was with a view, and I could find the code in the ALL_VIEWS table... but this does not seem to be the case here, as I can't see any ALL_X tables related to Stored Procedures)

    Thanks in advance for your help!

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool



    Try ALL|USER|DBA_SOURCE
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Aug 2004
    Location
    Buenos Aires, Argentina
    Posts
    28
    Quote Originally Posted by LKBrwn_DBA


    Try ALL|USER|DBA_SOURCE
    I get a "ORA-04043: object SYS.DBA_SOURCE does not exist" message. I'm using SQL*Plus: Release 8.1.7.0.0.

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Quote Originally Posted by panchopp
    I get a "ORA-04043: object SYS.DBA_SOURCE does not exist" message. I'm using SQL*Plus: Release 8.1.7.0.0.
    Then try all_source.....
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  5. #5
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    -- OR -- Have the DBA grant you SELECT ANY CATALOG role.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  6. #6
    Join Date
    Jul 2003
    Posts
    2,296
    read up on the differences between:
    user vs. all vs. dba
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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