Hi Tom,

I ran following statements in Oracle 10g Database:

SQL> SELECT version from v$instance

VERSION
-----------------
10.2.0.5.0
1 row selected.

SQL>

create or replace procedure sohail_test
is 
begin
  null;
end;

Procedure created.

SQL>

create or replace public synonym sohail_test for sohail_test

Synonym created.

SQL>

select  * 
from    dba_dependencies
where   name = 'SOHAIL_TEST'

OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE REFERENCED DEPENDENCY_TYPE
------------------------------ ------------------------------ ----------------- ------------------------------ -------------------- ----------------- ---------- ---------------
PUBLIC SOHAIL_TEST SYNONYM TLMDBO SOHAIL_TEST PROCEDURE HARD
1 row selected.

AND then I run the same statements on a 9i database:

SQL>

SELECT version from v$instance

VERSION
-----------------
9.2.0.8.0
1 row selected.

SQL>

create or replace procedure sohail_test
is 
begin
  null;
end;

Procedure created.

SQL>

create or replace public synonym sohail_test for sohail_test

Synonym created.

SQL>

select  * 
from    dba_dependencies
where   name = 'SOHAIL_TEST'

no rows selected.

I am unable to figure out the reason of why in 10g database the public synonym is being shown in dependencies view. Please could you help?

thanks
sohail