Re: PLS-00453

From: Nigel Thomas <nigel.cl.thomas_at_googlemail.com>
Date: Mon, 18 May 2009 10:10:16 +0100
Message-ID: <53258cd50905180210q251e3a8fwe6452d2f93aa3376_at_mail.gmail.com>

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-l Received on Mon May 18 2009 - 04:10:16 CDT