RE: Oracle Stored Proc - In/Out Variable example

[Olive, Christopher M Mr USACHPPM]

http://www.allaire.com/handlers/index.cfm?ID=8353&Method=Full&PageCall=/supp
ort/index.cfm

this is the KB article on the process.  it's kind of vague, but i used it as
a template for my own SPs in Oracle 8i.  ( i just started working on them a
few days ago. )

BTW, the mysterious "maxrows" parameter to CFSTOREDPROC param is
undocumented.  it shows up in the error message if you have strict attribute
checking turned on in your CF Admin, but nowhere is it actually documented.


if you have any questions, feel free to contact me on/off list.  it's a
subject that i think Allaire should have given more thought to when they
released CF.  (of course, i think 4.5.1 fixes it.  but we ALL can't have the
latest version (at least that's what my manager says...)).

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-----Original Message-----
From: Scott Rowe [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 17, 2000 1:43 PM
To: CF-Talk
Subject: Oracle Stored Proc - In/Out Variable example


Does anyone have an example of an Oracle stored proc with in/out values and
the example Code to go with it. I keep getting errors such as illegal
variable name/number  OR wrong number or types of arguments in call to
'USERCHECK' ORA-06550: line 1, column 7: PL/SQL: Statement ignored. I'm
stuck and I'm a novice with Oracle. Please help.

Scott


----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
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.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.