[thelist] oracle problems in php

apatrick at oracular.com apatrick at oracular.com
Tue Sep 12 09:43:48 CDT 2000

- and second:
- OCIFetchInto($r,&$results,OCI_ASSOC);
- gives me a strange error:
- OCIFetchInto: ORA-01002: fetch out of sequence
- What does that mean???

>From the Oracle Error messages manual:

ORA-01002 fetch out of sequence

     Cause: In a host language program, a FETCH call was issued out of
     sequence. A successful parse-and-execute call must be issued 
     before a fetch. This can occur if an attempt was made to FETCH 
     from an active set after all records have been fetched. This may 
     be caused by fetching from a SELECT FOR UPDATE cursor after a 
     commit. A PL/SQL cursor loop implicitly does fetches and may also 
     cause this error. 

     Action: Parse and execute a SQL statement before attempting to 
     fetch the data. 

More information about the thelist mailing list