Skip to Main Content

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!

Intersection/inside and buffer

525832Jul 31 2006 — edited Sep 20 2006
Hi, As I make to get the geometrys resultant of the intersection enters space objects of a table and the buffer of a point?

The buffer of the point I already obtained, but when I try SDO_RELATE or SDO_INSIDE occurs the errors:

My sql command:

SELECT square.idsquare
FROM square
WHERE
SDO_INSIDE(
square.geometry,
SDO_GEOM.SDO_BUFFER(MDSYS.SDO_GEOMETRY(3001, 1, MDSYS.SDO_POINT_TYPE(276, 1274, 0) , NULL, NULL), 200, 0.05, 'unit=m arc_tolerance=0.05')
) = 'TRUE';


ERROR in line 1: ORA-29902: error in the execution of ODCIIndexStart routine ()
ORA-13208: internal error during evaluation of the operator [window SRID you donate not match to layer SRID]
ORA-06512: in “MDSYS.SDO_INDEX_METHOD_10I”, line 369
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 18 2006
Added on Jul 31 2006
6 comments
1,169 views