Does any one here know a work around or the PHP function to retrieve an
output
variable from a IBMi stored procedure.
I'm using Ubuntu UnixODBC and PHP5.

Here's an example of my php code.

$qry = "call storedproc(?,?,?,?,?,?);

If($stmt = odbc_prepare($conn, $qry));
$success = odbc_execute($stmt, array($i1, $i2, $i3, $i4, $i5, $o6));
//after this executed the $o6 string variable is empty.
if($success){
//I tried odbc_result and odbc_result_all and I'm still not getting any
results

}

FYI my sixth parameter in IBMi stored procedure is set to INOUT and I can
see the value returned back when I debug the job.


Any ideas would be appreciated.

Thanks in advance

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.