"; $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); ?>