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.

please help me about sdo_relate

613550Dec 13 2007 — edited Dec 18 2007
object : I want get building polygons are in a road and building polygon is in 2 kilometer of that road.

1. I can buffer of road in 2 kilometer and make to new table
create table road_bufs as
select sdo_aggr_union(mdsys.SDOAGGRTYPE(sdo_geom.sdo_buffer(a.shape,b.sdo_diminfo,2),0.00001))
from fgds.SB_ROADC_LINE a,mdsys.SDO_GEOM_METADATA_TABLE b
where a.name = 'ถนนราชปรารภ' and b.sdo_column_name = 'SHAPE' and b.sdo_table_name='SB_ROADC_LINE'

2. I want select tag(Id of building polygon) from lb_building_poly
select a.tag,b.shape
from fgds.LB_BUILDING_POLY a, taxmap.road_bufs b
where sdo_relate(a.shape,b.shape,'mask=OVERLAPBDYINTERSECT querytype=window') = 'true'

It show error :
SQL Error: ORA-29902: error in executing ODCIIndexStart() routine
ORA-13207: incorrect use of the [SDO_RELATE] operator
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_9I", line 259
ORA-06512: at line 1

I use oracle 9i please tell me
thank you very much..........

Comments

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

Post Details

Locked on Jan 15 2008
Added on Dec 13 2007
#database-key-features, #spatial
5 comments
1,345 views