Display Oracle Spatial geometry

[amirshauli]

Hi all,

I have some geometries (about 5,000) that is store in Oracle Spatial as SDO_GEOMETRY
What will be the best and fastest way to get those geometries from oracle and display them in the map (ArcObjects).

I think of WKT,WKB, GML, UDT (user define type that represent sdo_geometry).

BTW
I don't have SDE and I don't want to use SDE.

Any help?

[amirshauli]

I want to change my question.
I checked and the fastest way to query those geometries from oracle spatial is UDT (User Defined Type).
The question is can ESRI read the UDT (oracle SDO_GEOMETRY)?
Or should I do some parsing in order to display it?

maybe It will be faster to use WKT because ESRI is familiar with the UDT format?

[amirshauli]

maybe It will be faster to use WKT because ESRI is familiar with the UDT format?

I meant maybe It will be faster to use WKT because ESRI is NOT familiar with the UDT format?

any help here?

[nicogis]

use query layer

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/What_is_a_query_layer/00s50000000n0000...

http://blogs.esri.com/Dev/blogs/geodatabase/archive/2010/04/14/Query-Layers-_4000_-ArcGIS-10.aspx

[amirshauli]

Thanks.
It's good to know ESRI have this functionality.
But actually I need something little different.
I can't let the client access the DB directly (security), So I have a server that pulls the geographic data for the clients and pass it on to them. I want to be able to take this data (UDT is the best way I think) and display it on the map.

How can I do it?
Can ESRI know how to read the SDO_GEOMETRY (UDT) type?
Should I need to cast the UDT to something else that ESRI can read?