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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
