Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Navigating database packages

Jeffrey KempDec 15 2013 — edited Feb 14 2014

I've just upgraded from 3.2.20.09 to 4.0.0.13 and was hoping that the package navigation had improved, but unfortunately doesn't seem to be - but perhaps I haven't looked in the right places yet.

1. What keyboard shortcut exists to jump from a declaration in the package spec to its implementation in the package body, and vice versa?

2. I tried clicking, CTRL+Up, CTRL+Down, double-click, CTRL+click, CTRL+doubleclick different declarations. Eventually it seemed to freeze for about 10 seconds, then raised a strange error "PL/SQL unit to_char does not exist"...

Unfortunately the help system isn't very helpful in this regard. Search on "keyboard shortcuts" - suggestions are "User Preferences for Data Modeller" and "SQL Developer Usage Suggestions", which includes a smattering of keyboard shortcuts. Including this one:

"In the window for a package definition, you can press Ctrl+click on a procedure or function name to perform the Open Declaration command, which opens the procedure or function implementation (body specification) in a new window."

It appears this might be a bug then. I have never seen this "Open Declaration" command.

3. I read about the blue arrows, but they sometimes appear on the wrong lines (so if you have a long list of function or proc specifications, the blue arrows appear on the blank lines in between them, which is rather confusing).

4. CTRL+click on a function or procedure - the cursor navigates to the bottom of the package. Why?

5. Sometimes when I click or hover over a function or procedure name it changes to blue+underline. I haven't worked out when exactly, it seem intermittent, disappears soon after, and it doesn't seem to serve any purpose. This existed in 3.2 it seems.

All that said, I like the new breadcrumb feature.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 14 2014
Added on Dec 15 2013
6 comments
3,655 views