Please, could you make this improvement as soon as possible, preferably in one of the beta-version for version 10? I am sure that I speak for hundreds of database package programmers, when I say that it would make a world of difference to us all to have a well implemented code completion.
It should be quite easy to merge the list of internal functions to the list of objects from the database views. The internal objects are already known by PLD, because they are shown in the code content pane (cursor parameters, private method parameters etc.)
Please also include constants, types etc. from the package header when doing code completion in the package body.
Please take another look at the rather large back catalogue of enhancements requests for code completion and try to implement as many as possible for version 10.
Also please try to make code completion work for PL/SQL arrays of records, e.g. myArray(2).myRecordColumn
Working code completion for myRecordColumn (after the end paranthesis and period) would be so sweeet...
Thumbs up for the developers!