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 Thanks in advance ! > > Hi all, > > I am trying to call a stored procedure which has 3 > input params and 1 out apram which is a refcursor. > I am using CF MX 7 > > I am getting this error - > "PLS-00306: wrong number or types of arguments in > call > to 'GET_METADATA' ORA-06550: line 1, column 7" > > This is my CF Code for calling the Stored Procedure > :- > === > <CFSTOREDPROC procedure = "METADATA.get_Metadata" > dataSource = "mydatasource" > returnCode = "No"> > > <CFPROCPARAM type = "IN" > CFSQLType = "CF_SQL_NUMERIC" > value = "pageid"> > > <CFPROCPARAM type = "IN" > CFSQLType = "CF_SQL_VARCHAR" > value = "myFormName"> > > <CFPROCPARAM type = "IN" > CFSQLType = "CF_SQL_VARCHAR" > value = "myfieldName"> > > > <CFPROCRESULT name = "metadataResult"> > </CFSTOREDPROC> > ======== > > > Below is the PACKAGE definition :- > PACKAGE METADATA > IS > > TYPE metadata_recordtype IS RECORD > ( > fieldName FORMINPUTCONTROL.FIELDNAME%TYPE, > fieldValue DATA_FIELDVALUE.fieldvalue%TYPE > ) ; > > TYPE metadata_curtype IS REF CURSOR RETURN > metadata_recordtype; > > > PROCEDURE get_metadata( > PAGEID IN Data_FieldValue.PageId%Type, > FORMNAME IN FORMCONTROL.FormName%Type, > INHERIT_FIELDNAME IN > FormInputControl.fieldname%Type, > METADATA_CURVAR OUT metadata_curtype > ); > END Metadata; > > > Please help ! > > Thanks in advance, > kn > > > > > > ______________________________________________________ > > Yahoo! for Good > Donate to the Hurricane Katrina relief effort. > http://store.yahoo.com/redcross-donate3/ > > __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:219062 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
