source code

[milind]

Hi

Not very sure whether this has been addressed already.

when we right click on a package or procedure and select view or edit option. The code is displayed. This is fetched from where, it is user_source or dba_source ?

If I login as user which is not having select any dictioanry I am not able to see the code. Looks like it is fetched from dba_source and not user_source
Is there any work-around or setting for taking it from user_source

Thanks

 

[Marco Kalter]

It is fetched from sys.all_source, unless you have enabled the "Use DBA views if available" preference (Tools > Preferences > Oracle / Options page), in which case it is fetched from sys.dba_source (if available).