";
$conn = oci_connect('scott', 'Son', 'localhost/orcl.gateway.2wire.net');
if (!$conn) {
$m = oci_error();
trigger_error(htmlentities($m['message']), E_USER_ERROR);
}
echo "connected to db";
$curs = oci_new_cursor($conn);
$stid = oci_parse($conn, "begin empt1_proc1(:curs);end;");
oci_bind_by_name($stid, ":curs", $curs, -1, OCI_B_CURSOR);
oci_execute($stid);
oci_execute($curs); // Execute the REF CURSOR like a normal statement id
echo "
parsed and executing
";
while($row = oci_fetch_row($curs))
{
var_dump($row);
echo "
";
}
oci_free_statement($stid);
oci_free_statement($curs);
oci_close($conn);
?>