Hi Tom,

I am trying to execute a remote package that does a simple print display. I can't get it to work.  This is what I have:

/**** remote side ****/

CREATE OR REPLACE PACKAGE p
IS
   PROCEDURE ln (val in VARCHAR2);
END;
/
show errors

CREATE OR REPLACE PACKAGE BODY p
IS

   PROCEDURE ln (val in VARCHAR2)
   IS
   BEGIN
      dbms_output.enable (1000000);
      IF length (val) > 255
      THEN
         raise value_error;
      ELSE
         dbms_output.put_line (val);
      END IF;
   EXCEPTION
      WHEN others
      THEN
         dbms_output.put_line (val);
   END;

END;
/
show errors

When I go to run this locally, I don't see my "hello":

/**** local side ****/


SQL> set serveroutput on;
SQL> exec c2a.p.ln@rmsdev06('hello');

PL/SQL procedure successfully completed.

What am I doing wrong???!

Thanks....!   

Jeff 

i have a procedure on remote with signature
REMOTE INSTANCE R1/SCHEMA S1:
Type array_t1 is table of varchar2(255);// can be record also here
 proc(p_array in array_t1 ,out sys_refcursor)
IS
{
..
..
out is populated ....
}
execute is granted on Type and Procedure to B1 . 

LOCAL INSTANCE L1/Schema B1
DBLINK to REMOTE is LNK created using S1 of Remote,
synonym PROC is created for S1.PROC@LNK.
when i describe the type in local
i get the error
SQL> desc S1.arr_t1@LNK
ERROR:
OCI-21700: object does not exist or is marked for delete

 !oerr ora 21700

21700, 00000, "object does not exist or is marked for delete"
// *Cause:  User attempted to perform an inappropriate operation to
//          an object that is non-existent or marked for delete. 
//          Operations such as pinning, deleting and updating cannot be
//          applied to an object that is non-existent or marked for delete.
// *Action: User needs to re-initialize the reference to reference an
//          existent object or the user needs to unmark the object.


Is this possible to execute such type of Remote Proc using collection as in parm and refcursor as out and if yes
what i need to do to resolve the issue above (is it grant or how it can be reinitialized )?