Home » RDBMS Server » Networking and Gateways » DtabaseLink error
- icon5.gif  DtabaseLink error [message #136539] Thu, 08 September 2005 10:51 Go to next message
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

Report message to a moderator

- Re: DtabaseLink error [message #136811 is a reply to message #136539] Sat, 10 September 2005 17:53 Go to previous message
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.

Report message to a moderator

Previous Topic: ORA-12154 TNS could not resolve the connect identifier specified.
Next Topic: Transparent Gateway to Sybase
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 02 09:00:18 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.