Not sure if I'm understanding the question, but any cursors in your stored procedure would be a return type, i.e. you wouldn't be looping over it within the proc (unless it was looped/closed for related business logic). By the time you call the proc from CF, CF is just saving the result set for you, and then you have to do something else to loop over the result set. cfstoredprod doesn't have to close a cursor because it doesn't open one or loop over one.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335405 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
