Re: oci to sql conversion?

Hi Volker,

Thanks for your response. My scenario is like this: We do not control the database at all. I can say that is part of a legacy system, but that is not the whole story either. We provide an application that has to make use of this database though. It was written by an amalgamation of developers that did not really understand C++ or oracle, but knew enough to get something that appears to be working. Now that the hard problems are cropping up (memory leaks and the like) I am tearing my hair out from frustration.

I saw from the online docs that you can query the "normal" columns from the database, and I've seen the sql. One of them might look like this:

SELECT clast_id, geometry FROM map_clasts T1 WHERE MINE = 'MPONENG MINE' and SDO_RELATE(GEOMETRY,
mdsys.sdo_geometry(2003,NULL,NULL,mdsys.sdo_elem_info_array(1,1003,3),mdsys.sdo_ordinate_array(-100,-100,100,100)),'mask=ANYINTERACT querytype=WINDOW') = 'TRUE';

pretty standard stuff, actually.

My problem here is that I want to get to the geometry information, like the types, and the ordinates and the like. So what my question should really have been is; Is there a way to query the information that is contained in the geometry type so that the results come in a table?

Regards,
Pieter Received on Thu May 04 2006 - 11:45:50 CDT