echo "Second Insert\n";
$s = oci_parse($c, "insert into t_tab values ( 1,-1)");
$r = oci_execute($s, OCI_DEFAULT); // Explore the difference with and without OCI_DEFAULT
if (!$r) {
$m = oci_error($s);
trigger_error('Could not execute: '. $m['message'], E_USER_ERROR);
}
$r = oci_commit($c);
if (!$r) {
$m = oci_error($s);
Correction: the two oci_error() calls after oci_commit() should use
the $c connection resource, not $s, e.g.:
$m = oci_error($c);
trigger_error('Could not commit: '. $m['message'], E_USER_ERROR);
}
$s = oci_parse($c, "drop table t_tab");
oci_execute($s);
?>
--
Email: christopher.jones@oracle.com
Tel: +1 650 506 8630
Blog: http://blogs.oracle.com/opal/
Free PHP Book: http://tinyurl.com/ugpomhome