Did you? GRANT SELECT ON SYS.ALL_ARGUMENTS TO METADATA
-Adam 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. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:219150 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