[cx-oracle-users] Re: SDO_GEOMETRY data type

[Jani T. <re...@lu...>]

Mikel Larreategi kirjoitti:
> Anthony Tuininga wrote:
> 
>> Yes, there are plans to support such data types but they are not very
>> firm. I haven't personally had any need for such data types yet and
>> the project I am working on right now is taking a lot of time -- so it
>> hasn't been a priority. Patches (as always) are welcome. :-)
> 
> 
> Thanks for your answer.
> 
> I've never written C extensions for Python, so I don't think I could do 
> it now... Perhaps if I had more time to do it... but now I can't do it, 
> and I just need to access those data. I'll ask DBA to change the 
> datatype or to export those data as string if it's possible.

Well you can get around this problem by using Well-known Text format 
(WKT), since Oracle 10g supports that (You're using that right?). So, 
instead getting SDO_GEOMETRY column use column.GET_WKT() you can also 
save data in WKT format. IIRC there is also support for WKB, which is 
bit faster but needs more parsing since it's binary. With Oracle 9i + 
Spatial add-on you're out of luck.

I.e.:   SELECT ID, GEOMLOC.GET_WKT() FROM GEODATA_TABLE;

-- 

Jani Tiainen