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; >Kugh, > >You have a different issue then. CF works fine with everything prior >to Oracle 10g r2. > >-Adam > >On 9/23/05, kugh ng <[EMAIL PROTECTED]> wrote: >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:219137 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
