Code Assistant issue for schema objects when logged in as schema owner

[Alex M]

I have been using PL/SQL Developer for almost two years and love it! My chief complaint however is not being able to use the Code Assistant for schema objects when logged into that schema.

I have the ability to do so from SQL Developer and don't think its a permissions issue.

Can someone please direct me to the preference to enable that?

Thanks!

 

[Hilarion]

Maybe try enabling "Use DBA Views if available" in Tools / Preferences / Oracle / Options?

 

[Alex M]

Thanks so much Hilarion - that option was disabled so I enabled as you recommended. I even restarted the PL/SQL Developer and logged back into the schema.

Unfortunately, that did not enable the Code Assistant for my schema objects when logged in as the schema owner.

I did note the following prior to posting form a prior post and did confirm that I have access to all the public all_* views:
"You will need select privileges on the sys.all_* views, which are granted to public by default."

I did want to note that the Code Assistant works beautifully when referencing objects not owned by the logged-in schema.

Any other thoughts or suggestions would be most welcome!

 

[Hilarion]

Try changing user selection filter to "".

Check contents of "CANames.sql" file (in PL/SQL Developer folder) and verify if the queries contained in there do return objects you are trying to refer to, when using Code Assistant.