Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Get result of a stored procedure : Oracle / PHP

554910Jan 7 2007 — edited Jan 8 2007
Hello,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 5 2007
Added on Jan 7 2007
2 comments
1,430 views