hi,
You could try the following:
<?php
$connection = db_connect(); // connect to the db
// The stored proc.
// name: test_ret_func.
$query ="Begin
:vNum :=test_ret_func;
end;";
$result = OCIParse( $connection, $query);
// Bind the parameters.
OCIBindByName($result,":vNum",$val);
OCIExecute($result);
echo "result is $val <br>";
?>
To use more than one out parameter you need to bind that many variables by calling the OCIBindByName function that many times.
This is how a stored procedure can be called which does not have an out parameter.
<?php
require ("oraConf/config.php3");
require ("oraLibrary/functions.php3");
$connection = db_connect();
$query ="Begin
test_ret_proc;
end;";
$result=query($query,$connection);
?>
I hope it helps.
-- Pp
