Home » RDBMS Server » Networking and Gateways » dblink problem
dblink problem [message #245326] Sat, 16 June 2007 00:38 Go to next message
Messages: 3
Registered: June 2007
Location: india
Junior Member
Hello friend,
I am using oracle9i Server.
While fetching data from another Server(oracle 8i) using snapshot, an error message is coming.

ORA-01002:fetch out of sequence
ORA-02063:preceding line from <dblink>

please help me.

bye bye
Re: dblink problem [message #245341 is a reply to message #245326] Sat, 16 June 2007 02:03 Go to previous message
Frank Naude
Messages: 4516
Registered: April 1998
Senior Member
It is most likely a program error:

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.
Previous Topic: Accessing an Oracle DB from outside a firewall
Next Topic: Two listeners up
Goto Forum:

Current Time: Sun Aug 20 05:01:55 CDT 2017

Total time taken to generate the page: 0.01084 seconds