> 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.
To the best of my knowledge, you can only return a recordset from Oracle using native drivers. > Second, when using native drivers, can multiple record sets > be returned from one stored proc in CF 4.5/Unix? Yes, using one CFPROCRESULT tag within your CFSTOREDPROC tags for each recordset within the stored procedure itself. > 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. I don't know all the details myself; you might take a look at the CF 5 and Oracle stored proc presentation by Dave Gallerizzo here: http://www.cfugorama.com/cfugorama/devcon.cfm Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
