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