PLS-00453
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-lReceived on Mon May 18 2009 - 03:57:11 CDT