PLS-00453
- From: "Toth, Istvan 5 (GE Money)" <istvan5.toth@xxxxxx>
- To: <Oracle-L@xxxxxxxxxxxxx>
- Date: Mon, 18 May 2009 10:57:11 +0200
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:
