I'm having an issue with seeing package/procedure/function source code for schemas other than the one I'm logged in with. Every time I try to see the source code for them I get the following text:
-- auto-generated definition
-- No source text available
I am using an Oracle connection with an account that has DBA privileges, and when using sql developer or sql*plus can see all source code for any object. I've synchronized all of my schemas, as well. Has anyone come across this issue, and is there any way to fix this, other than logging into each of the schemas directly to see the object source code?