Re: oci to sql conversion?

pieter schrieb:
> Just to be complete, this is what I came up with. It is VB6 code, and
> it works ;)
>
> Volker, it is mostly based on what you said. As you might see, I get
> the sdo_elem_info collection, but what does these values mean? One of
> my results is (1, 2, 1)... Anyway. Thanks for your help :)
If you are telling me that you do not know the SDO geometry object type then my strong advise is to spend a day or two reading this up in the documentation.
The elem_info array basically tells oracle what to do with the coordinates, like connecting them with straight lines or arcs or where an outline ends and a hole starts, all sorts of things basically. With an otn account (free of charge) you can read http://download-east.oracle.com/docs/cd/B19306_01/appdev.102/b14255/toc.htm . Or get at the pdf and print out the relevant sections. If this is a longer term project, try to get http://tinyurl.com/mvbvb .

Working with spatial geometries isn't trivial.

On the other hand, most users are content with creating them. The only reason to actually parse them is if you want to display them or feed them into some other system.
In all other cases, you simply enter the data, query for matching sets and display the names or other properties of the matching objects, like "TV station X overlaps with TV station Y".

Here's another article (geared towards DML) that shows a bit about how to work with geometries:
http://forums.oracle.com/forums/thread.jspa?messageID=38575&tstart=0#38575

Lots of Greetings!
Volker Received on Fri May 05 2006 - 06:59:24 CDT