Definition for <public synonym> was not found (v 7.1)

For security reasons, the owner of all objects is a separate user (schema). And we got next error when we work with public synonym.

Reproduce:

  1. SQL for creating object in other schema (HR) and public synonym:

create or replace package hr.test_pkg is
procedure a(v varchar2);
end;
/

create or replace package body hr.test_pkg is
procedure a(v varchar2) is
begin
null;
end;
end;
/

create or replace public synonym test_pkg for hr.test_pkg
/

  1. Open new SQL editor and type:

begin
test_pkg.a(‘1’);
end;

test_pkg.a(‘1’);

test_pkg

  1. When pressing Ctrl and clicking on first and second functions we get error:

12:07:44 Definition for test_pkg.a was not found

  1. When pressing Ctrl and clicking on third function we go to spec of package (setting Go to Definitions for package programs set to “Open body”).

Hi smithsv,

Thanks for your report this issue, i think the third function should not do Go to Definitions neither. we have create Defect SQLNAV-1753 for you, we will try to fix soon.

Thanks,

Michael