Unfortunately, the standard tags for this will fetch the whole result from the ref cursor or the first n rows only (as specified in the cfprocresult tag).
Were the apps you've seen this done in desktop apps, not web apps? CF effectively ends the DB connection after each request (sure it can be pooled, but as far as the each request is concerned a new connection is provided from this pool), which is what you'd expect from a web app. However, you can use Java directly inside CF so it's possible you may be able to get somewhere with a native Java class. On 5/25/07, Dave O <[EMAIL PROTECTED]> wrote: > Hi. To start with I am an Oracle DBA, I know little to nothing about > ColdFusion. I am supporting an application using ColdFusion MX7. They call > one of our stored procedures which dynamically builds a SQL statement and > returns to them via a RefCursor. The problem we are having is that the query > could possibly return hundreds of thousands, or maybe a million or more rows. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279168 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
