Use USER_SOURCE or DBA_SOURCE if you do not see USER_PROCEDURES.
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.
Click Here to Expand Forum to Full Width