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

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.  


This is the calling site:  

  • Created on 2009. 05. 14. by 501472338 declare
  • Local variables here result szamlaszamtomb; begin
  • Call the function result :=''); 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 FROM oasis2_szamlanyitasok sz2 where sz2.fe_id=id_in) order by; num INTEGER;
num := 0;
for p in processes loop
num := num + 1;
sz := szamlaszam('','');
sz.szamlaszam := p.a;
sz.alszamlaszam := p.b;
szT(num) := sz;
end loop;
return szT;

Received on Mon May 18 2009 - 03:57:11 CDT

Original text of this message