-
Use USER_SOURCE or DBA_SOURCE if you do not see USER_PROCEDURES.
svk
-
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
-D
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|