fetch out of sequence

Hi there ,

see code below :

$conn = OCILogon("user", "pwd" , "DB");
$stmt = OCIParse($conn,"select * from tabel");
OCIExecute($stmt);
while ( OCIFetch($stmt) ) {

.........................................}

I wanted to see a simple oracle table on my webpage....

If I use this code for an oracle table hosted on an windows server, it works fine.

If I use this code for an oracle table hosted on a unix server , then I receive : ORA-01002: fetch out of sequence . However the select is working via sql-net.

I 'm using apache service included with oracle 9.2.

What can be going wrong ?

Gerry Received on Thu Oct 30 2003 - 07:38:32 CST