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/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:218686
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
