oci_parse causes web page to time-out
559761Feb 2 2007 — edited Feb 3 2007The following code works fine from the command line... And if I take out the oci_parse statement, it works fine from the web page. If I put oci_parse in though, it goes out to lunch and never comes back. What am I missing? This is on apache (apache2triad edge install) using PHP 5 on windows. I have larger code snippets that take the data and print it and that works from the command line but not the web page. I kept adding code until it stopped working on the web page and it stopped working with the introduction of the oci_parse line.
****************start code segment******************
<html>
<body>
<?php
if ($conn=OCILogon("user", "passwd", "db")) {
echo "Successfully connected to Oracle!<br />";
;
;
} else {
$err = OCIError();
echo "Oracle Connect Error " . $err[text];
}
echo "Test. <br />";
$query = "select count(Tally), sum (Tally) from reporter_status where BU_6 = 'OBM_IHUB' and FirstOccurrence > sysdate - 1";
echo "Query Done.<br />";
$statement = oci_parse($conn, $query);
echo "Parse Done.<br />";
OCILogoff($conn);
?>
</body>
</hmtl>
****************end code segment***********
thanks
brad