HI,
I have a EE database 11gR2.
I get the folowing error:
ERROR at line 2:
ORA-29532: Java call terminated by uncaught Java exception: Error:
Message:Error in ReverseGeocoder
Nested exception is:
oracle.jdbc.driver.OracleSQLException: ORA-13249: SDO_NN cannot be evaluated
without using index
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.PRVT_IDX", line 9
ORA-06512: at "MDSYS.SDO_GCDR", line 806
ORA-06512: at "MDSYS.SDO_GCDR", line 863
When I run the code:
case 1:
select
sdo_gcdr.reverse_geocode
(
'MYSPATIAL',
(
SDO_GEOMETRY
(
2001,
8307,
SDO_POINT_TYPE
(
-122.41356,
37.7932878,
NULL
),
NULL,
NULL
)
),
'US'
)
from
dual;
case 2:
select
sdo_gcdr.reverse_geocode
(
'MYSPATIAL',
sdo_geometry
(
2001,
8307,
sdo_point_type
(
-122.41356,
37.7932878,
null
),
null,
null
),
'US'
)
from
dual;
Does someone has an idea about what the problem is?
I can use SDO_NN for queries in schema MYSPATIAL without any problem.
Thanks by advance for any tip.
Kind Regards