Skip to Main Content
Forums

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!

Lat,Long to SDO_GEOMETRY

CrackerJackApr 1 2008 — edited Apr 4 2008
Hi everyone,

I need some help.

I have teh lat and long.How do I convert teh lat , long to SDO_GEOMETRY?


I have tried creating a column geom with SDO_GEOMETRY data type and then

update table-name set geom = SDO_GEOMETRY(2001, 8307, SDO_POINT_TYPE(Longitude, Latitude , NULL), NULL, NULL):

but i can't create a spatial index on that geoloc.It gives me OCI errors and index is invalid..Should I rebuild it?

Any help would be much appreciated.

Message was edited by:
CrackerJack

Message was edited by:
CrackerJack
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 2 2008
Added on Apr 1 2008
#database-key-features, #spatial
11 comments
4,237 views