I was wondering if I could get some clarification concerning Oracle stored procs and CF 4.5 and 5.
First of all, the way the 4.5 documentation reads, it seems as if you need to be using native drivers to use stored procs. After playing around with the ODBC drivers (CF 4.5/Unix) and seeing some posts in the forums, I noticed that running a stored proc works fine with ODBC if it does not return a record set . However, if I try and return a record set (a simple SELECT statment), the code fails (I followed the KB articles to return an Oracle record set, as I know record sets are returned differently in Oracle as opposed to SQL Server). Can a record set, and ideally multiple recordsets, be returned from a stored proc using Oracle ODBC drivers? We are using the Merant ODBC drivers for Oracle on CF 4.5/Unix. Second, when using native drivers, can multiple record sets be returned from one stored proc in CF 4.5/Unix? Last, have there been improvements (i.e., ease of use, enhancements) to returning Oracle stored proc record sets in CF 5? If so, can you give me an overview of the changes or point me in the direction of where I can find some documentation? I'm trying to justify the upgrade from CF 4.5 to 5, and this issue would be a major selling point to my boss. Thanks, and sorry for the 20 questions!! Dave Carabetta Senior Developer Reis, Inc. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
