Is it possible to connect Oracle with ArcGIS for doing spatial query?
Google suggests you use ArcSDE, or possible Direct Connect