I have an Oracle 8 problem. Unfortunately, I can't use the OCI functions and must use the ORA functions. The code below looks fine to me. It will return *almost* all of the rows, but then the script just dies with no warnings or errors, even though I have called error_reporting(E_ALL). I do get the following error message in an Apache error log: Ora_Parse failed (ORA-00936: missing expression -- while processing OCI function OPARSE).
Here's my code: <? $query = "select $columns from $table where $where_clauses"; ora_parse($cursor, $query) or die("<br>ora_parse() failed: ".ora_error()); ora_exec($cursor) or die("<br>ora_exec() failed: ".ora_error()); print '<br><br><a name=results><table border=1>'; $rowcount = 0; while(ora_fetch($cursor)) { print '<tr>'; for($i=0; $i<sizeof($columns); $i++) { $cell_data = ora_getcolumn($cursor, $i); if($cell_data === false) die("ora_getcolumn() failed: ".ora_error()); print "<td>$cell_data</td>"; } print "</tr>\n"; } print '</table>'; ?> Thanks for any advice. Matt