Querying Database Links broken in 6.0.2?

[djkucera]

This used to work in PL/SQL Developer 5.1.6 but is giving an error in 6.0.2:

1) Log in to Oracle via PL/SQL Developer
2) New SQL Window
3) SELECT * FROM SYSOBJECTS@somedblink
4) F8 (execute)
5) Hit the double arrow to fetch all rows

It fails after showing 100 rows with

ORA-01002: fetch out of sequence

We get this error in WinSQL if Autocommit is set on. I checked the PL/SQL Developer preferences, the check box is NOT on for "Autocommit SQL".

Tried with both HSODBC link and TG4MSQL link, same error.

Seems to work sporadically after the first error, but always fails the first time after logging in.

Help?
Thanks.
DK.

 

[Marco Kalter]

Can you try the following?

1. Open a new SQL Window
2. Execute "savepoint abc"
3. Execute your query
4. Fetch all rows

Let me know if this "fixes" the problem.

 

[djkucera]

Originally posted by Marco Kalter:
Can you try the following?

2. Execute "savepoint abc"

Let me know if this "fixes" the problem.

If I execute this savepoint command first in the SQL window, the link server query loads the entire result set successfully.

If I open a new SQL window but do NOT execute the savepoint first, the link server query fails every time.

Can this be fixed in an upcoming release/patch?

Thanks.
DK.