RE: [KCFusion] Stored Procedures

[doug boude]

I use SQL stored procedures with MX. The error you're getting sounds quite 
reminiscent of errors I get when I fail to pass my sproc the parameters 
and/or data types it's expecting, or fail to accomodate a parameter it is 
passing back out to me. My thoughts are to verify that the cfprocparam tags 
are correct.

Doug  :0)


From: "Smith, Jim" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: <[EMAIL PROTECTED]>
Subject: [KCFusion] Stored Procedures
Date: Wed, 17 Mar 2004 08:18:43 -0600
I am trying to call an oracle stored procedure in MX. Do any of you
folks use them? I can get a function to work fine, but the stored
procedure gives me ORA-06550: line 1, column 7: PLS-00306: wrong number
or types of arguments in call to 'BY_DEPT' ORA-06550: line 1, column 7:
PL/SQL:
I have been using the example in the Macromedia article found here:
http://www.macromedia.com/devnet/mx/coldfusion/articles/stored_procs.htm
l
Jim Smith
Database Programmer/Analyst
MU Enrollment Management - Student Information Systems
130 Jesse Hall
Columbia, MO  65211
Phone Number: 573-884-6980
FAX Number: 573-884-4530
Email Address: [EMAIL PROTECTED]

_________________________________________________________________
MSN Toolbar provides one-click access to Hotmail from any Web page � FREE 
download! http://clk.atdmt.com/AVE/go/onm00200413ave/direct/01/

=========================================================
Kansas City ColdFusion User Group's website & listserv is 
hosted through the generous support of Clickdoug.com
To send email to the list, email  [EMAIL PROTECTED]
To (un)subscribe, email [EMAIL PROTECTED] with your request.
For hosting solutions http://www.clickdoug.com
Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1. 
======================================================