PLS-00453

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@xxxxxxxxxxxx('');
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; 


Other related posts: