Here's one I used:
Example of Php program invoking a PL/SQL anonymous block. The block can
then call a PL/SQL compiled function or stored procedure on the
server. The OCIBindByName function is used to pass values into or out
of the PL/SQL anonymous block. In this example, a compiled PL/SQL
function on PRD1 (get_eicsum) is invoked. Two variables are passed
in (SCC and SIC) and one is returned (result).
<?php
$conn = OCILogon("scott","tiger","PRD1");
$result = 0;
$scc = 12345678;
$sic = 1234;
$stmt = OCIParse($conn, "begin :x := get_eicsum(:a, :b); end;");
OCIBindByName($stmt, ":x", &$result, 10);
OCIBindByName($stmt, ":a", &$scc, 9);
OCIBindByName($stmt, ":b", &$sic, 5);
OCIExecute($stmt);
echo "Result: $result<BR>";
OCIFreeStatement($stmt);
OCILogoff($conn);
?>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
