I would try taking out all the non-required parameters (debug and returncode). I'd also try passing in the username and password associated with this stored procedure. I don't _really_ think that's your issue. But, I'd try it.
I'd also try passing in hard-coded values that you know work when you run it from sql+. I've also not used your particular syntax for returning a ref cursor. Here's an example of a package spec that works for me (note that it doesn't return a record, it just returns a generic ref cursor). CREATE OR REPLACE PACKAGE dg_p_cowsin1 AS TYPE GenericCursorType IS REF CURSOR; PROCEDURE pcowsin1 ( inherdcode IN integer, outresults OUT genericcursortype, outErrorNo OUT VARCHAR2); END dg_p_cowsin1; / On 9/23/05, kugh ng <[EMAIL PROTECTED]> wrote: > > I DO have # signs for my vairable values and not for my constant values > .... and I continue to get "wrong type/number PLSQL error" > > I didnt know that CFPROCPARAMS need a closing / tag. After looking at your > code I added these - but didnt help > > This is how my CF code is (with the actual input values) > <CFSET x=2> > <CFSTOREDPROC procedure = "METADATA.get_Metadata" > dataSource = "#Request.Site.DataSource#" > returnCode = "No" > debug="Yes"> > > <CFPROCPARAM type = "IN" > CFSQLType = "CF_SQL_INTEGER" > value=#x# /> > > <CFPROCPARAM type = "IN" > CFSQLType = "CF_SQL_VARCHAR" > value = "Column Layout"/> > > <CFPROCPARAM type = "IN" > CFSQLType = "CF_SQL_VARCHAR" > value = "FIC_Inherit_Template"/> > <CFPROCRESULT name = "metadataResult" /> > </CFSTOREDPROC> > > > > >On 9/23/05, kugh ng <[EMAIL PROTECTED]> wrote: > > > >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. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:219157 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
