Get result of a stored procedure : Oracle / PHP
554910Jan 7 2007 — edited Jan 8 2007Hello,
I am trying to get the result of a stored procedure with PHP. Here is my code :
___________________________
$varIn1 = 1;
$varIn2 = 0;
$conn = OCILogon("xxx", "xxx", 'xxx');
$stmt = OCIParse($conn, "BEGIN maProcedure(:varIn1, :varIn2, :varOut1); END;");
OCIBindByName($stmt, ':varIn1, $_varIn1);
OCIBindByName($stmt, ':varIn1, $_varIn1);
OCIBindByName($stmt, ':varOut1, $varOut1);
OCIExecute($stmt, OCI_DEFAULT);
echo "statut: " . $varOut1;
OCIFreeStatement($stmt);
OCILogoff($conn);
___________________________
I get no error message, but I don't get the value of $varOut1. What am I doing wrong ?
Thanks in advance !
Helene