> Did you use that in Oracle before? The reason I asked is that
> in ColdFusion knowledge base, for article # 8353, it said that
>
> "Oracle stored procedures do not return result sets in the
> traditional sense. Consequently, it is not possible to generate
> a query in ColdFusion using an Oracle stored procedure."
This is no longer the case. CF now supports the retrieval of recordsets from
Oracle stored procedures as long as the stored procedure returns a reference
cursor (as described by Vani Kolli earlier in this thread) and as long as
you use CFSTOREDPROC to call the stored procedure.
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
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
