---------- Original Message ---------------------------------- From: "Everett, Al" <[EMAIL PROTECTED]> >"Errors can occur with Oracle Reference Cursors when used with packages >containing multiple procedures. These errors are caused by a problem with >the updated JDBC driver provided with this Updater Release." > >I seem to be running into this issue. I'm getting a 'wrong number or type of >parameters' error when I try to use a stored procedure that returns a ref >cursor with CFMX. Identical code and the same database works fine on CF5. >I'm seeing this with the Oracle driver that comes with CFMX and the JDBC >thin driver
This is supposed to be fixed in Updater 3 (there's a new JDBC driver coming with Updater 3). However, a workaround I believe is that you can't have 2 stored procedures that return refcursors in the same package. So, our workaround in the meantime was to put each Stored Procedure that returned a refcursor into its own package. Or, you can wait till Updater 3 is released, whenever that is. (I've heard mid-March, but that's not second-hand info) Scott -------------------------------- Scott Brady http://www.scottbrady.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
