Changing all your packages is a "workaround"? We have we have at least 10 packages all containing between 5 and 50 Procs that return ref cursors. It is not really an option to split all these packages into separate packages with single procs returning a ref cursor. it really undremines the whole idea that you create packages to organize your application code. It looks like we are still unable to use our two subscription copies of mx even this long after it's release.
Maybe we will have to look more closely at moving to bluedragon for our next upgrade. Thanks, Frederick Scott Brady wrote: >---------- 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
