 DtabaseLink error [message #136539] |
Thu, 08 September 2005 10:51  |
brandointheweb
Messages: 25
Registered: August 2005
Location: Germany
|
Junior Member |
|
|
Hello from Germany,
I created a database-link to MSSQL using Transparent Gateways!
Select-statements work quite good if they have results not more than 200 datasets!
But when I try a select on a table with over 200 datasets I get the ORA-errors:
ORA-01002: FETCH....(closed CURSOR) and
ORA-02063: Preceding line from VIDEOTHEK (which is my databaselink)
How comes?
Would You give me a hint?
Best regards from Germany
MArlon
|
|
|
|
| Re: DtabaseLink error [message #136811 is a reply to message #136539] |
Sat, 10 September 2005 17:53  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
