Hi,
I would say that it will not work out-of-the-box because GeoServer does not have X/Y or CSV datastore and what could be done with Mapserver through the GDAL virtual format http://www.gdal.org/drv_vrt.html is not supported. But if you absolutely need such feature it is for sure doable. You can contract a Geoserver developer to make a new datastore or if you are in a hurry you can install Mapserver to read X/Y data from Oracle, publish it as WMS and cascade that layer with Geoserver.
The real question is: Why would you like to do so? You do not need to pay for Oracle locator and with it you can add a new column of datatype SDO_GEOM into your table and populate it from your X and Y columns. If you have an old system in production and X/Y are updated from some application, make a trigger and do inserts and updates into SDO_GEOM every time when X or Y are touched.
-Jukka Rahkonen-
···
Lähettäjä: Nachtigall, Jens (init) [mailto:Jens.Nachtigall@anonymised.com]
Lähetetty: 12. syyskuuta 2014 15:52
Vastaanottaja: geoserver-users@lists.sourceforge.net
Aihe: Re: [Geoserver-users] Point Geometry in lon/lat columns of non-spatial db
A „does not work, you must use a spatial db to hold point coordinates” would help me, too 
Does nobody know?
Cheers,
Jens