Hi,
in our company we are considering to use sqldeveloper. Our application is heavily built on PL/SQL Packages which are situated in different schema users. Coding one procedure in a package usually has the need of using Package-Procedures of at least one other schema user. All Packages which can be called from another schema user ("interfaces to this user") do have a public synonym and the appropriate grants. In our current environment we are used to call those procedures of others users by merly referencing the public synonym than referencing them by explicitly using the user name.
Due to the big amount of available procedures and functions we depend on a reliable code completion to show all available members of a referenced package for productivity issues of our development. During the evaluation of the practical use of sqldeveloper (as replacement for toad) I had no success in getting such described behavior. Obviously sqldeveloper Completion Insight only works when packages of other users are referenced directly (with the preceding use of the corresponding schema user in which the package is located).
I already have found the option of including the synonyms for completion insight but the behavior does not really change. It seems to me that this option does not have any effect regarding our development needs. The only difference I see in using (respectively not using) the option of including the synonyms is that packages of the same user can be referenced without using the schema user when the synonyms are included.
Does anybody know if this behavior is "works as designed" or have I missed something?
Thanks!