SQL & PL/SQL

Oracle 9.2.0.6 on Windows 2003
Has anybody encountered this before and been able to resolve.

SQL> connect SchemaA/password@NSN1
 
SQL> create database link MyLink1
2 connect to REMDB identified okm135
3 using 'STAF'
4 /
 
Database link created.
 
SQL> create or replace VIEW rem_mydocs as
2 (select * from mydocs@MyLink1)
3 /
 
View created.
 
SQL> grant select on rem_mydocs to UserA ;
 
Grant succeeded
 
SQL> Create or replace function fn_rem_mydocs 
2 return Sys_RefCursor 
3 IS
4 v_rc Sys_RefCursor;
5 begin
6  open v_rc for 
7       select * from rem_mydocs ;
8  return (v_rc);
9 end;
10 /
 
Function created.
 
SQL> grant execute on fn_rem_mydocs to UserA;
 
Grant succeeded
 
SQL> connect UserA/test975@NSN1
Connected.
 
SQL> create or replace synonym rem_mydocs for SchemaA.rem_mydocs;
 
Synonym created.
 
SQL> create or replace synonym fn_rem_mydocs for SchemaA.sp_rem_mydocs ;
 
Synonym created.
 
SQL> select count(*) from rem_mydocs ;
 
 COUNT(*)
---------
      324
 
SQL> var g_ref refcursor
SQL> begin :g_ref := fn_rem_mydocs; end;
2 /
 
SQL> print g_ref
ERROR:
ORA-02019: connection description for remote database not found