Thanks to James, Tanguy, Andrew and Deanna for your help. It appears that the explicit cursor is the way to go.
Now Ive got the procedure working it appears that the jdbc thin driver is not up to the job when calling the sp's from cf. Goddang. Michaelb. ----- Original Message ----- From: "James Holmes" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Friday, December 09, 2005 7:53 AM Subject: Re: Calling Oracle Stored Procedures from CF > No I never said that it was bad - I said that it simply won't work if > the query returns more than one row, which it looks like it does. > > On 12/8/05, Dave Carabetta <[EMAIL PROTECTED]> wrote: > > > Just a side note on your cursor comment, as you seem to suggest that > > not using an explicit cursor is somehow bad. I would actually advise > > *against* explicit cursors in almost all cases. Here's supporting > > evidence from Oracle guru Tom Kyte himself, who demonstrates > > conclusively with thorough test cases that implicit cursors actually > > perform *better* than explicit cursors: > > -- > CFAJAX docs and other useful articles: > http://jr-holmes.coldfusionjournal.com/ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226650 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
