A forgotten Link to Oracle Spatial Geocoder is here.
And here is a JSP with a small demo page.
There one can see how the GEOCODER is queried and the result being printed out.
A good page to illustrate an SQL Query on Geo-Data !
Reverse Geocoding here (lower part) and usage of the XML Format here:
Give it a try !