why didn"t errors show up

why didn"t errors show up

am 23.11.2008 23:22:57 von Fred Silsbee

OK I had to (thanks to Jack Nav Zanen)
(1) remove the ";" off the sql statement
(2) change "'" to """

but why did NOTHING appear on the browser screen?

$db = "(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = LMKIIIGDNSID)
)
)";
if ($conn=oci_connect('landon', 'rumprocella',$db))
{
echo "Successfully connected to Oracle.\n";
// OCILogoff($conn);
}
else
{
$err = OCIError();
echo "Oracle Connect Error " . $err;
}

$stid = oci_parse($conn, "insert into log_book_id values (logid.nextval, TO_DATE('08/12/1973','MM/dd/YYYY'),'B-17','N5787G',1,1.8)");

if (!$stid) {
$oerr = OCIError($stid);
echo "Parse error:".$oerr;
exit;
}

if (!oci_execute($stid )) {
$oerr = OCIError($stid);
echo "Exec error:".$oerr;
exit;
}

oci_commit($conn);
OCILogoff($conn);
echo "end";
?>







--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php