[MAPSERVER-USERS] How to map attribute data (non-geom) from Oracle (not Spatial)?

[Bill Wordsworth]

What is the best way to map attribute data (non-geom) from Oracle (not
Spatial) using MapServer?

Can I do this?
LAYER
	NAME "states_shapefile"
	DATA "path/states_shapefile"
	...
	JOIN
	    NAME "oracle"
		CONNECTIONTYPE ogr
	    CONNECTION "..."
	    TABLE "oracle_states_table"
	    FROM "oracle_name"
	    TO "shapefile_name"
	    TYPE ONE-TO-ONE
	END
	# FILTERITEM ""
	FILTER "governor='Arnold'"
END
http://mapserver.gis.umn.edu/docs/reference/mapfile/join#example-2-join-from-shp-file-to-postgresql-table

If not, what is the best way around?
* Spend $$$ for Oracle Spatial
* Nightly convert attribute data to shapefile
* Nightly convert attribute data to PostGIS

Any thoughts on the maintenance cost for each?
Cheers, Bill