Problems accessing table with SDO_GEOMETRY type

[AlexP]

as soon as we add these changes, we send you a night build of the products, including these changes.

[AlexP]

We have changed behavior. Now, MaxArrayItem is not a constant, but a variable in the MemData module. You can set the number of elements in an array by yourself.

[uffek]

That is a sub-optimal solution, since we don't know how many coordinates there may be in a specific dataset. We can only try with some fairly big value and hope it is sufficient with no warning if it isn't.

And even so, it is still slow compared to the mssql and postgresql implementations.

Finally, when is it available? Version 6.3 from April do not have it.

Really disappointed.....

[AlexP]

The fixed version will be released next week.

[Aufhauser]

In my programs I use the SDO_UTIL.TO_WKBGEOMETRY function to change geometry from object type to blob.
example:
SELECT FieldA, FieldB, SDO_UTIL.TO_WKBGEOMETRY(GeomFieldName) from MyTable
this works in OCI and direct mode and the WKB-format is easy to read.

Stefan

[eduardoelias]

In my programs I use the SDO_UTIL.TO_WKBGEOMETRY function to change geometry from object type to blob.
example:
SELECT FieldA, FieldB, SDO_UTIL.TO_WKBGEOMETRY(GeomFieldName) from MyTable
this works in OCI and direct mode and the WKB-format is easy to read.

Stefan

Stefan, I wonder if you could give me little more information.
I am trying to retrieve the WKB format from Oracle 11g XE. I do this for PostGIS and can parse it just fine.

However when running the SELECT SDO_UTIL.TO_WKBGEOMETRY(GeomFieldName) on Oracle SQL Developer it retrieves a result only with NULL values. It should be showing the binary (well, in MSSQL and POSTGIS it does work)

When trying the same thing via Unidac it happens either, every row comes with this column NULL

I would like to know if you tested it with Oracle 11g XE. I know this version of oracle is not a full version at least it does not come with all the spatial stuff, but SDO_UTIL should be working.

Any hint would be appreciated!

Thanks

[Aufhauser]

Sorry I used this code with enterprise and standard editions of oracle (10g, 11g) not with XE