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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

sdo_within_distance

680483Jan 29 2009 — edited Feb 1 2009
When I try to run this sql:

select p.state_name from usa p where
sdo_within_distance(p.geom,
(select geom from usa where state_name = 'California'),
'distance=450 unit=km'
) = 'TRUE';


I recieve the following error:

ORA-29902: error in executing ODCIIndexStart() routine
ORA-13207: incorrect use of the [No UNIT support without SRID] operator
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 286
This post has been answered by Simon Greener on Jan 31 2009
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 1 2009
Added on Jan 29 2009
#database-key-features, #spatial
9 comments
2,232 views