Oracle doesn't return a "RETURNCODE", and setting RETURNCODE="Yes" will
usually result in the Oracle error that you have given below. Set it to
"No" or take it out and try it again.
> -----Original Message-----
> From: Rose, Israel [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 24, 2001 2:30 PM
> To: CF-Server
> Subject: RE: Limitations of CFPROCPARAM
>
>
> <CFSTOREDPROC Procedure="Tally_Data.Summate" datasource="mydatasource"
> username="myusername" password="mypassword" RETURNCODE="Yes">
> <CFPROCPARAM Type="IN" CFSQLTYPE="CF_SQL_INTEGER" VALUE=#Surv_Number#>
> <CFPROCPARAM Type="IN" CFSQLTYPE="CF_SQL_CHAR" VALUE=#X#>
> </CFSTOREDPROC>
> <CFSET Elem_Per = CFSTOREDPROC.STATUSCODE>
>
> As I stated, this works with the CF_SQL_CHAR type hard-coded in
> the proc and
> sending in the Integer type alone; or I can encode the char as an integer
> and decode it within the proc but it will only take a single procparam in
> either case. Thanks for your help.
>
> IROSE
>
> > -----Original Message-----
> > From: Mark Stewart [SMTP:[EMAIL PROTECTED]]
> > Sent: Monday, September 24, 2001 11:18 AM
> > To: CF-Server
> > Subject: RE: Limitations of CFPROCPARAM
> >
> > You aren't limited. Or, I should say, I've never run into this problem
> > before. I run my stored procs on SQL Server and I pass many params of
> > varying types. It might help if you showed me what your proc looks like.
> > That is, show the cf code that calls the stored proc. I'm assuming
> > you've checked to make sure your not using any Oracle reserved words,
> > etc.
> >
> > Mark
> >
> > -----Original Message-----
> > From: Rose, Israel [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, September 24, 2001 10:13 AM
> > To: CF-Server
> > Subject: Limitations of CFPROCPARAM
> >
> >
> > Can anyone tell me why I am limited to use of only one CFPROCPARAM upon
> > calling a CFSTORED PROC?
> >
> > I get the following message if I use the Stored Proc with either a
> > non-numeric Proc Param or more than one Proc Param as an attribute. Any
> > insights?
> >
> >
> > Error Diagnostic Information
> >
> > Oracle Error Code = 1036
> >
> > ORA-01036: illegal variable name/number
> >
> > SQL = "Tally_Data.Summate"
> >
> > Data Source = "insited"
> >
> > The error occurred while processing an element with a general
> > identifier of
> > (CFSTOREDPROC), occupying document position (82:1) to (82:117) in the
> > template file
> > F:\htdocs\material\sw_supplier_rating\Tally_Temp_Data.cfm.
> >
> >
> >
> >
> > IROSE
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
