Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

USER_SOURCE and other system tables for procs, etc.

SyswizardMar 28 2014 — edited Mar 28 2014

I queried the USER_SOURCE table using my schema and I only got a handful of procedures, packages, and functions.

When I saw a function in a query, it was not in USER_SOURCE, but it ran fine.

How could I see this function and it's source code ?

This post has been answered by Frank Kulash on Mar 28 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 25 2014
Added on Mar 28 2014
3 comments
494 views