Dave, Curious if you trie granting SYS.ALL_ARGUMENTS to the schema owner?
-Adam On 9/23/05, Dave Carabetta <[EMAIL PROTECTED]> wrote: > 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:219065 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
