My Oracle stored procedure returns 2 arrays of the two columns, name (varchar2) and id (number) I defined two arrays as output paramters in my CF code. But I get " wrong number or types of arguments" error I wanted to know how I can access arrays which are returned by stored procedures. Thanks Vani -- CF Code -- <cfset g = ArrayNew(1)> <cfset u = ArrayNew(1)> <cfstoredproc procedure="abc"> <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="n" value="abc" null="No"> <cfprocparam type="Out" cfsqltype="CF_SQL_VARCHAR" variable="u" dbvarname="name" null="Yes"> <cfprocparam type="Out" cfsqltype="CF_SQL_INTEGER" variable="g" dbvarname="id" null="Yes"> </cfstoredproc> _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
