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!

sdo_distance units

627886Apr 29 2008 — edited May 6 2008
select sdo_geom.sdo_distance((select geom from twopoints where id=1), (select geom from twopoints where id=2), 0.05, 'unit=mile')
from twopoints;

this query works until I add the parameter 'unit=mile' then it returns ORA-13292: can not specify unit for geometry without a georefernenced SRID. The table twopoints has a record in USER_SDO_GEOM_METADATA with an SRID of 8307.

I would also welcome suggestions/critiques of the query in general.

Thanks,
David
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 3 2008
Added on Apr 29 2008
#database-key-features, #spatial
4 comments
1,406 views