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!

PlSql Navigation with Ctrl-Click in Package

Jason McCleskeySep 8 2020 — edited Sep 9 2020

Trying to make the official switch from Toad to SqlDeveloper - 20.2.  If I open a package from the database, the options for navigating around the package are very limited.  Trying to see if there's something obvious in preferences or my expectations that I'm missing.  If I'm in a procedure within a package, I would expect to be able to do some keystroke (Ctrl-Click?) that would jump to whatever I'm pointing at.  Example in below pseudo-code I'd like to be able to easily jump to procedure 123 or cursor cur_test with a ctrl-click or some other shortcut.

Note - I get the message at the bottom of the screen that says "Click on an identifier with the Control key down to perform the "Go to Declaration"" but it doesn't matter how I click or hover (no mouse - laptop touchpad only) I can't get it to do the jump.

Example:

PAKAGE ABC

PROCEDURE 123

PROCEDURE 456

    CURSOR cur_test IS

    select something from somewhere;

BEGIN

  FOR rec IN cur_test  -- I'd like to be able to jump from cur_test here to the actual cursor

  LOOP

           procedure 123;  -- I'd like to  be able to jump from 123 here to the actual procedure

  END LOOP;

END;

What am I missing?  SqlDeveloper 20.2 on Oracle 12c (EBS) using Java 8 right now. 

Thanks,

Jason M

Comments
Post Details
Added on Sep 8 2020
5 comments
1,654 views