R: [PHP-DB] OCIFetchInto: ORA-01002: fetch out of sequence
| From: | Roberto Sartor | Date: | Mon, 11 Sep 2000 15:49:38 +0000 |
| Subject: | R: [PHP-DB] OCIFetchInto: ORA-01002: fetch out of sequence | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-2795@lists.php.net to get a copy of this message | ||
Reported by manual "Oracle 7.3, Server messages"
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.
Ciao
Roberto
> -----Messaggio originale-----
> Da: Peter Van Dijck [mailto:peter@vardus.com]
> Inviato: lunedì 11 settembre 2000 17.42
> A: php-db@lists.php.net
> Oggetto: [PHP-DB] OCIFetchInto: ORA-01002: fetch out of sequence
>
>
> OCIFetchInto: ORA-01002: fetch out of sequence
> Any idea what this means? I searched the archives but
> couldn't understand
> the answers there....
> Peter
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail:
> php-list-admin@lists.php.net
>