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!

ORA-13207: incorrect use of the [More than 2D not supported] operator

126135Aug 30 2004 — edited Sep 15 2004
Oracle 8.1.7.4:

The same query works in an Oracle DB on Linux and Windows, but in a Solaris it gives me the following error:

cc_redes_met_coaxial@ORAG2> SELECT lot_f.lot_id id,
ROUND(MDSYS.SDO_GEOM.SDO_DISTANCE(lot_geom.geometry, ped_geom.geometry, 0.5),2) dist
FROM lot_f,
pedestal_f,
G_GEOMETRY_0 lot_geom,
2 G_GEOMETRY_0 ped_geom
WHERE lot_f.feat_num = lot_geom.feat_num
3 AND pedestal_f.acc_point_id = 611
AND pedestal_f.feat_num = ped_geom.feat_num
4 AND lot_f.g_version+0 = 0
AND (lot_f.g_next_version > 0 OR lot_f.g_next_version IS NULL)
5 AND pedestal_f.g_version+0 = 0
6 AND (pedestal_f.g_next_version > 0 OR pedestal_f.g_next_version IS NULL)
AND MDSYS.SDO_WITHIN_DISTANCE(lot_geom.geometry, ped_geom.geometry,'distance = 100' ) = 'TRUE';
7 8 9 10 11 12 13 14 SELECT lot_f.lot_id id,
*
ERROR at line 1:
ORA-29902: error in executing ODCIIndexStart() routine
ORA-13207: incorrect use of the [More than 2D not supported] operator
ORA-06512: at "MDSYS.SDO_INDEX_METHOD", line 84
ORA-06512: at line 1

The data is in 3D. I took a look at the trace file but no useful information. It does not have to be 2d, right?
I can use SDO_WITHIN_DISTANCE with data in 3d, can't I?

Does anyone know what is going on? Maybe a bug?

Regards,
Alex
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 13 2004
Added on Aug 30 2004
16 comments
461 views