Hi there ,
The code below gives me a webpage in table format about a certain table from oracle.
However , for very large table , the system is giving me the following error: OCIFetch: ORA-01002: fetch out of sequence.
Why it is working for certain tables and not for large ones ?
What can I do about it ?
Thx in advance
$conn = OCILogon("user", "pass" , "db");
$stmt = OCIParse($conn,"select * from table");
OCIExecute($stmt);
print("<TABLE BORDER=1>\n");
print ("<TR ALIGN=LEFT VALIGN=TOP>");
while ( OCIFetch($stmt) ) {
print ("<TR ALIGN=LEFT VALIGN=TOP>");
$ncols = OCINumCols($stmt);
for ( $i = 1; $i <= $ncols; $i++ ) {
$column_value = OCIResult($stmt,$i);
print ("<TD>" . $column_value . "</TD>\n");
}
print ("</TR>\n");
}
print("</TABLE>\n");
OCIFreeStatement($stmt);
OCILogoff($conn);
