Hyperlinks to variable declaration

[Vinny]

Holding the control key and placing the mouse pointer over a variable turns it into a hyperlink to the variable's declaration. I love this feature. However, I have found that when I am logged in as a user that is not the owner of the programming object (in my case, a package), these links do not work if the declaration is external to the object I am working in. Example:

CREATE OR REPLACE PACKAGE user1.pk1 IS
    gc_string1 CONSTANT VARCHAR2(10) := 'Hello';
END pk1;
/

CREATE OR REPLACE PACKAGE user1.pk2 IS
    FUNCTION print_msg( p_text IN VARCHAR2 DEFAULT pk1.gc_string1 )
    RETURN VARCHAR2;
END pk2;
/

CREATE OR REPLACE PACKAGE BODY user1.pk2 IS
    FUNCTION print_msg( p_text IN VARCHAR2 DEFAULT pk1.gc_string1 )
    RETURN VARCHAR2 IS
    BEGIN
        dbms_output.put_line( p_text );
    END print_msg;
END pk2;
/

Now if I log in as user2 (this user is the developer user that has create/modify procedure privs for all schemas), the link for pk1.gc_string1 will not work. This works as expected if I am logged in as user1.

Is there some configuration setting I may be overlooking?

Thanks

 

[Vinny]

Okay, not a perfect example, my function does not return a value, but hopefully, you get what I mean.

 

[Marco Kalter]

The hyperlink function apparently does not pick up the context of the owner. We'll try to enhance this.

 

[Vinny]

Marco,
I believe this extends beyond the hyperlinks. I think the whole of the code assistant needs to be enhanced. In my example, if I type "pk1." and wait for the code assistant nothing happens.

Thanks,
Vince

 

[Marco Kalter]

Yes. That would be the same underlying parser...