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 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.