dblink problem [message #245326] |
Sat, 16 June 2007 00:38 |
balu1010
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
balu
|
|
|
Re: dblink problem [message #245341 is a reply to message #245326] |
Sat, 16 June 2007 02:03 |
Frank Naude
Messages: 4587 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.
|
|
|