<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
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
