Hi. During some upgrades of SQLnav versions (don’t know which one exactly) ctrl+clikcing on a package/procedure got a little different.
Example:
CREATE OR REPLACE PACKAGE mpa_test_pkg
IS
PROCEDURE test(p_name IN VARCHAR2);
END;
CREATE OR REPLACE PACKAGE BODY mpa_test_pkg
IS
PROCEDURE test(p_name IN VARCHAR2)IS BEGIN NULL; END;
END;
BEGIN
mpa_test_pkg.test(p_name => ‘abc’);
END;
This procedure executes fine and ctrl+click will open the package (or body - it depends on preferences).
If I misspell the parameter name, there’s error:
That’s fine but when I click on the function name again with CTRL, the package won’t open and it shows a message in the Output:
I think that’s also kind of fine, because it’s true. There isn’t such a procedure with that specific parameters.
Although I would want at least just to open the package with CTRL+click to see the parameters and correct my mistakes. I tried to click on the package body - nothing.
Maybe it would be a little misleading to fix this “bug” to go to the first procedure in the package with the name (regardless of the misspelled parameters) because there could be other procedures and the actual one I’m trying to call is maybe somewhere further, but I think it worked that way earlier. And most of the times there really will be only one procedure (let’s not get carried away with overloaded procedures :)).
Anyway while I was posting this, I discovered that there IS a way to get it work like I want it! Just click on the opening bracket right after the procedure name!
I don’t know is it a feature or not. I just want to get your opinion on this.