DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12
  1. #11
    Join Date
    Jul 2000
    Use USER_SOURCE or DBA_SOURCE if you do not see USER_PROCEDURES.

  2. #12
    Join Date
    Jul 2003
    Dba_Source and User_Source views
    was what I was looking for. Thanks Tomcat & Dave23uk.

    I should have mentioned oracle version (8.1.7) but thought that this was such a generic question.

    Anyway user_procedures view in 10g will not show us definition, so we need User_Source or dba_source to get the object defintion.

    Thanks again

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