On 9/23/05, kugh ng <[EMAIL PROTECTED]> wrote:
> OK then I am back to where I started.
> What do I need to do to solve this problem? I have been struggling with this
> for some days now. SO someone please let me know what I need to do here
>
> I get error "PLS-00306: wrong number or types of arguments in call to
> 'GET_METADATA' ORA-06550: line 1, column 7"
>
> But the procedure works perfectly from Oracle SQL prompt. I get error only
> when calling from CF code.
>
> I am using CF MX 7 with Oracle 10.1.0.3.0.
>
> I am facing the same ditto problem with CF MX 6 Developer edition with Oracle
> 9.2.0.5
>
> To recap again I use the following CF code :-
>
> ===== <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>
>
> And this is the definition of my Oracle Stored Procedure :-
> ======
>
> 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;
>
>
You need pound signs around your values!! Otherwise you're just
sending in string values representing the field names. Try this:
<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>
Regards,
Dave.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219140
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
