Toad World® Forums

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


#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”).

#2

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