Skip to Main Content

ODP.NET

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-13268: error obtaining dimension from USER_SDO_GEOM_METADATA

SeshuNareshAug 8 2012 — edited Aug 14 2012
I am receiving an error message if i send the query (Oracle Spatial) from my .NET application using ODP.NET. I am using OR operator and SDO_WITHIN_DISTANCE. Please find the query below. The query work perfectly when I run the query in SQL developer

SELECT * from TABLE1
....
WHERE SDO_WITHIN_DISTANCE( GEODATA.SHAPE, (SDO_CS.TRANSFORM(sdo_util.from_gml311geometry('<gml:Point srsName="SDO:4326" xmlns:gml="http://www.opengis.net/gml">
<gml:pos xmlns:gml="http://www.opengis.net/gml">14 50</gml:pos>
</gml:Point>'),4326)), 'distance=9999.98906889') <> 'True'
))
OR (COLUMN1 IN
(SELECT * from TABLE 2
WHERE SDO_WITHIN_DISTANCE( GEODATA.SHAPE, (SDO_CS.TRANSFORM(sdo_util.from_gml311geometry('<gml:LinearRing xmlns:gml="http://www.opengis.net/gml" srsName="SDO:4326">
<gml:pos xmlns:gml="http://www.opengis.net/gml">14 50</gml:pos>
<gml:pos xmlns:gml="http://www.opengis.net/gml">1 1</gml:pos>
<gml:pos xmlns:gml="http://www.opengis.net/gml">20 20</gml:pos>
<gml:pos xmlns:gml="http://www.opengis.net/gml">80 80</gml:pos>
<gml:pos xmlns:gml="http://www.opengis.net/gml">14 50</gml:pos>
</gml:LinearRing>'),4326)), 'distance=9999.98906889') <> 'True'
))))

I have a table GEODATA with SRID as 4326 and I have created the index also.

If I replace "</gml:Point>'),4326)), 'distance=9999.98906889') <> 'True'" with "</gml:Point>'),4326)), 'distance=9999.98906889') = 'True'" everything works fine.

Its very urgent. Any help would be greatly appreciated.
This post has been answered by Alex Keh-Oracle on Aug 14 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 11 2012
Added on Aug 8 2012
4 comments
377 views