ORA-1003 Fetch out of sequence

Hi,
our database (V7.3.2 on Solaris 2.5) responds to one users SELECT * FROM USER_TABLES;
with

[snip 123 rows]
ERROR:
ORA-01002: fetch out of sequence

123 rows selected.

The doc says
01002, 00000, "fetch out of sequence"

// *Cause: This error means that a fetch has been attempted from a cursor


//         which is no longer valid.  Note that a PL/SQL cursor loop


//         implicitly does fetches, and thus may also cause this error.


//         There are a number of possible causes for this error, including:


//         1) Fetching from a cursor after the last row has been retrieved


//            and the ORA-1403 error returned.


//         2) If the cursor has been opened with the FOR UPDATE clause,


//            fetching after a COMMIT has been issued will return the error.


//         3) Rebinding any placeholders in the SQL statement, then issuing


//            a fetch before reexecuting the statement.


// *Action: 1) Do not issue a fetch statement after the last row has been


//             retrieved - there are no more rows to fetch.


//          2) Do not issue a COMMIT inside a fetch loop for a cursor


//             that has been opened FOR UPDATE.


//          3) Reexecute the statement after rebinding, then attempt to


//             fetch again.



The statement is issued via SQL*Plus 3.3 from an NT Workstation connecting
via SQL*Net V2.3, so we have no direct influence on SQL*Plus's cursor
handling.
What is the cause for this error? The database seems completely
intact and running.
Can anybody help?

Thanx, Robert.

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/   Now offering spam-free web-based newsreading