Re: Problem with cfstoredproc

["rhaddan"]

Hi,

 Thanks for the reply. I should have posted more code. I'm already doing what 
you suggested (code below). More testing leads me to believe that the issue may 
be to do with the returncode that the iSeries stored procedure requires as a 
passed parameter. If I try to call the program via SQL in cfquery, I receive an 
error that IN, OUT, and INOUT are not valid for the first parameter, which is 
the returncode.

 The procedure executes with a status code of 0. I'm trying to find 
documentation on what that status code means.

 <cfstoredproc procedure="myLib.myProcName" datasource="myDatasource" 
returnCode="Yes" debug="yes">
           <cfprocresult name="computeInterest">
           <!--- my cfprocparams --->
        </cfstoredproc>
        <cfdump var="#computeInterest#">