If you use stored procs at all you're going to want to use the drivers that come with CFMX. The ones that come with Oracle won't let you process result sets, and they also have issues with varchar2 return types.
I tried using the drivers that come with Oracle with CFMX professional and we actually upgraded to Enterprise just to get the Oracle drivers because we had so many issues with the JDBC drivers. -----Original Message----- From: Dave Hatz [mailto:[EMAIL PROTECTED] Sent: Thursday, September 21, 2006 5:46 PM To: CF-Talk Subject: Oracle JDBC Drivers vs. CF Oracle Drivers We are setting up a new box with CFMX 7.0.2, running on Windows 2003 Web Server Edition with IIS6. We have an Oracle 9i Database running on a W2K server. I am curious to the pros/cons of using Oracle Drivers that come with CFMX7 or use the Oracle JDBC drivers from Oracle? I am looking for performance issues only. Which is faster? Thanks, Dave Hatz ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253889 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
