> 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@xxxxxxxxxx
Tel: +1 650 506 8630
Blog: http://blogs.oracle.com/opal/
Free PHP Book: http://tinyurl.com/ugpomhome
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
