Use of ORACLE PL/SQL procedure with link in SQR

[Emma Vavra <evavra@LELAND.STANFORD.EDU>]

Hi,

I am trying to call an ORACLE PL/SQL  procedure  from a package
in the SQL paragraph in SQR program.
The package  is defined in the local database but contains a call to
a procedure in a different database via a link
The link is defined as a public link.  The PL/SQL  block that I
am using in the SQR works perfectly well if I execute it in SQL Plus, but
does not seem to work from the SQR.   
Has anybody tried to do this? Is it working for you? Can anybody point me
to any documentation?

This is the error . The error appears at the point that the local
procedure actually calls the remote procedure via a link.

              
Thanks for your help

                 
Emma

The block being exeduted
begin-procedure Process-Test
    Display 'Started  Process-Test.... '
    LET $MINE = ''
    LET $ACTIVITY = '0ZZZ001' 
    LET $ALL_SEQMENTS = ''

   Begin-SQL  On-Error = DB-Error
        DECLARE
          
lv_coa_activity           
VARCHAR2(7);;
          
lv_segments               
VARCHAR2(50);;
        BEGIN
        
EVAVRA.get_coa_pkg.GET_SEGMENTS('0ZZZ001',lv_segments);;
         $MINE := LV_SEGMENTS;;
        end;;
  End-SQL

2fe7fb5b.jpg