connecting to remote table

From: Julia Sats <julia.sats_at_sympatico.ca>
Date: Thu, 7 Aug 2003 20:51:12 -0400
Message-ID: <uvCYa.6690$pq5.923544_at_news20.bellglobal.com>

Hi,

I created some procedures that get data from tables of remote DB . Only I had problem with one table.

this is my procedure :

procedure GetModel(model_cd in varchar2, model_desc out varchar2) is begin

select model_description
into model_desc
from ksnv039_at_edwlink
where model_desc_code = model_cd;

end getmodel;

and this is error:
12:56:16 SQL> show errors
Errors for PACKAGE BODY PROJECT:

LINE/COL ERROR

---

283/1 PL/SQL: ORA-04052: error occurred when looking up remote object

         KA31KSN2.KSNV039_at_EDWLINK.US.ORACLE.COM
         ORA-06553: PLS-215: String length constraints must be in range (1


.. 32767)


         ORA-06553: PLS-215: String length constraints must be in range (1

.. 32767)

After I created view : create view ksnv039 as select * from ksnv039_at_edwlink; and rewrite my procedure for this view - everything fine.

What problem can be here?

thanks Received on Fri Aug 08 2003 - 02:51:12 CEST