At work I was able to convince my boss to consider using ColdFusion for the web interface to our Oracle database instead of the antiquated Oracle Web ToolKit we've been using for a while. In looking for ColdFusion & Oracle sites I've found the following references:
OraFusion.com
ColdFusion Best Practices for Oracle Databases
Oracle PLSQL in CFQUERY
Simple ColdFusion Stored Procedure Example