Try it without putting the out variable in the procparam - just use the procresult.
On 9/20/05, Quinn Ng <[EMAIL PROTECTED]> wrote: > > 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"> > > <CFPROCPARAM type = "OUT" > CFSQLType = "CF_SQL_REFCURSOR" > variable = "METADATA_CURTYPE"> > <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/ > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218687 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
