On 9/23/05, Quinn Ng <[EMAIL PROTECTED]> wrote: > Please read my problem below - which I had posted a > couple of days ago. > I am basically trying to get a REF CURSOR as an output > from the stored procedure in my CF code. > > I continue to face this problem i.e get error > "PLS-00306: wrong number or types of arguments in > call to 'GET_METADATA' ORA-06550: line 1, column 7" > > I was told that there was issue with some versions of > CF with some Oracle Drivers. > But could someone tell me what do I need to do to fix > it? > Also I didnt really find much info on it on this > website. > > I have tried this on CF MX 7 with Oracle 10g > I am using Oracle Database 10g Release 2 (10.2.0.1.0) > JDBC Drivers in this case. > > and also CF MX 6 Developer Edition with Oracle 9i > I am using the (macromedia datadirect ?)default driver > in this case >
You cannot use Oracle 10g Release 2 with ColdFusion MX if you have stored procedures that return ref cursors. The DataDirect drivers, version 3.3 and 3.4, that ship with ColdFusion MX (all versions) do not properly support the release. DataDirect 3.5, which you can download for a 15-day trial directly from the DataDirect site, does indeed work, and I know Macromedia has verified the issue (I filed the bug, which is how I know) and is internally investigating a future solution to the issue. Regards, Dave. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219063 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
