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>


 

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-l
Received on Tue May 19 2009 - 08:12:14 CDT

Original text of this message