Tool for code Navigation in PL/SQL

Question

I have to study and modify a big and poorly documented codebase written in pl/sql. I use Oracle SQL Developer to navigate through it, but it become tedious because there is not a "go to declaration" nor "find usages" option so I have to go manually to the referred package to find the function or procedure I want to understand, or grep an offline copy to find the usages.

I have tried to setup vim+ctags, but exuberant ctags gets confused by case insensitiviness.

So the question is, which tools allow to easily navigate through PL/SQL code?

Answer 1

PL/SQL Developer, from Allround Automations has some nice features to navigate through code. You can download and install a full-feature trial version that will last you one month. Afterwards, if you like the tool and want to go on using it, you will have to pay a (modest) fee.

Answer 2

Try Tobys PLSQL Editor. It gives you:

• Syntax highlighting
• F3 jump to code
• Package outlines
• Code completion
• Compile to database with error highlighting
• Auto header generation using PLDoc

I'm still searching for a good tool to look at dependencies. You can query the data dictionary to find package dependencies but it doesn't go down to the level of procedures/functions within the packages themselves or line numbers within each package.