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.

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
#database-key-features, #spatial
16 comments
370 views