Spatial: well known text with Oracle 9.2

From: Andreas Mosmann <>
Date: Tue, 16 Aug 2011 13:58:50 +0200
Message-ID: <>


in the SDO_UTIL - package of version 9.2 there is no way to convert from geometry to well known text and back.
How can I do this?

My main prob is the following:

There are MyDB, RemoteDB

in MyDB I try

select AFunctionThatReturnsGeoInformation_at_RemoteDB(My.Field1, My.Field2) from TableX My;

I get the error
ORA-30626: - "function/procedure parameters of remote object types are not supported"

When I use a function returning Varchar2 there is no problem, but it is impossible to return Geometry- Objects.
It seems to be clear, because data types could be a little different. Thats why I look for a way to handle this by WellKnownText. (I do not know, whether the data becomes to big, but I don't hope so)

Thank you

wenn email, dann AndreasMosmann <bei> web <punkt> de
Received on Tue Aug 16 2011 - 06:58:50 CDT

Original text of this message