RE: PLS-00453
From: Toth, Istvan 5 (GE Money) <"Toth,>
Date: Tue, 19 May 2009 15:12:14 +0200
Message-ID: <CC62ED7D8059D0438D84127EFBC4B6BC0585969B_at_BUDMLVEM02.e2k.ad.ge.com>
Date: Tue, 19 May 2009 15:12:14 +0200
Message-ID: <CC62ED7D8059D0438D84127EFBC4B6BC0585969B_at_BUDMLVEM02.e2k.ad.ge.com>
Nigel,
Thanks for the answer, I forwarded to the developer.
Regards,
Istvan
From: Nigel Thomas [mailto:nigel.cl.thomas_at_googlemail.com] Sent: 2009. május 18. 11:10 To: Toth, Istvan 5 (GE Money) Cc: Oracle-L_at_freelists.org Subject: Re: PLS-00453 2009/5/18 Toth, Istvan 5 (GE Money) <istvan5.toth_at_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? ----- Istvan You could create a wrapper function (at the remote db) which unpacks the user defined type szamlaszamTomb into regular scalar variables; then return those variables as output parameters to the caller at the local db. Regards Nigel
-- http://www.freelists.org/webpage/oracle-lReceived on Tue May 19 2009 - 08:12:14 CDT