Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting the SRID from SDO_Geometry

506155Apr 18 2006 — edited Apr 18 2006

I apologise in advance for asking this question but I am a complete novice of Oracle and wondered if anyone could help.

I have loaded Ordnance Survey Mastermap into OracleXE using a data loader and would now like to see what the loader has stored the SRID number as within the object SDO_GEOMETRY. In order to get OS Mastermap into Mapguide I would like this to be set to null but I can't seem to write the sql command that will tell me what it is currently set as.

So far I have tried various versions of select geoloc (the sdo-geometry column) from topo_area where rownum=1. This keeps bringing back the error ORA-00932: inconsistent datatypes: expected number got MDSYS.SDO_GEOMETRY.

I would appreciate any help in writing the sql, thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on May 16 2006

Added on Apr 18 2006

#database-key-features, #spatial

2 comments

7,667 views