I'm somewhat new to ArcObjects so forgive me if I lead you astray...
I would double-check that you're NOT using Sql Server commands for an Oracle database.
Oracle has an sdo_anyinteract() function, here's an example...
SELECT parcel.g3e_fid AS parcel_fid
FROM hcc_parcel_ar parcel
WHERE sdo_anyinteract (
parcel.g3e_geometry,
SDO_GEOMETRY (2001,
NULL,
SDO_POINT_TYPE (x_coord, y_coord, NULL),
NULL,
NULL)) = 'TRUE'
Also, your sql statement has Shape in it. I know sql server has a Shape object, which leads me to think that it's intended for Sql Server, but of course you could name a field Shape in Oracle as well.