[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