PLS-00453

From: Toth, Istvan 5 (GE Money) <"Toth,>
Date: Mon, 18 May 2009 10:57:11 +0200
Message-ID: <CC62ED7D8059D0438D84127EFBC4B6BC05819FE1_at_BUDMLVEM02.e2k.ad.ge.com>



Hello list,  

Need a help from plsql gurus.
We try to call a function over db link. After calling we got "PLS-00453: remote operations not permitted on object tables or user-defined type columns". Any idea?
Thanks in advance.  

Istvan  

This is the calling site:  

  • Created on 2009. 05. 14. by 501472338 declare
  • Local variables here result szamlaszamtomb; begin
  • Call the function result := ul.alszamla_to_moris_at_bproct.world(''); end;

This is the remote site:

CREATE OR REPLACE FUNCTION UL.alszamla_to_moris (ID_IN IN VARCHAR2) RETURN szamlaszamTomb is
szT szamlaszamTomb := szamlaszamTomb (); sz szamlaszam;
CURSOR processes IS SELECT MEMO || UGYFELSZAM AS A, ALSZAMLA AS B from oasis2_biztositek b2 where szamlanyitasid in (SELECT sz2.id FROM oasis2_szamlanyitasok sz2 where sz2.fe_id=id_in) order by b2.no; num INTEGER;
begin
num := 0;
for p in processes loop
num := num + 1;
szT.extend;
sz := szamlaszam('','');
sz.szamlaszam := p.a;
sz.alszamlaszam := p.b;
szT(num) := sz;
end loop;
return szT;
end;

--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 18 2009 - 03:57:11 CDT

Original text of this message