Using a Simple Faceted Search APEX Map Region, I want ot add the ability to do a Rectange Map Change and automatically filter the items displayed in a corresponding classic report. This is done in the Sample Maps region page 123.
In my app. adding an SDO_ANYINTERACT filter as in the Sample Maps application page 123 is giving me the error:
- Ajax call returned server error ORA-29902: error in executing ODCIIndexStart() routine for .
Map Region w Faceted Search works great BEFORE I add the SDO_ANYINTERACT where clause:
where sdo_anyinteract(
geometry,
mdsys.sdo_util.from_geojson( :P123_BBOX )
) = 'TRUE'
The GEOMERY - SDO_GEOMETRY column is registered and indexed.
What am I missing?
Does this SDO_ANYINTERACT simply not work in conjunction with Faceted Search on a map region?
Thank you - Karen