Entry

What does the OCI error "fetch out of sequence" mean?

Sep 7th, 1999 08:20
Nathan Wallace, Onno Benschop,

Fetch out of sequence usually means that you are trying to read from a
cursor that has no data left (like EOF).

The error usually looks something like this:

    Warning : OCIFetchInto: ORA-01002: fetch out of sequence in 
                                       type1.inc on line 36

Your read loop should look like this:

    $stmt = ociparse($conn,"select ...");

    while (ocifetch($stmt))
    { // work with the data...
    }

    // no all data for the select is read!

    ocifetch($stmt); // this will cause an ORA-01002