";
$stid = oci_parse($conn, "select * from ptab");
oci_execute($stid, OCI_DEFAULT);
oci_fetch_all($stid, $res);
var_dump($res);
echo "";
}
for ($i = 0; $i < 10; $i++) {
$a[] = 'value '.$i;
}
$c = oci_connect("hr", "hrpwd", "//localhost/orcl");
$s = oci_parse($c, "BEGIN mypkg.myproc(:c1); END;");
oci_bind_array_by_name($s, ":c1", $a, count($a), -1, SQLT_CHR);
oci_execute($s);
do_query($c)
?>
|