Heterogeneous select fails

gavin01 · Post by **gavin01** » Wed 14 Jan 2009 20:45

Hi,

I'm using the Oracle Heterogeneous services to connect to a SQL Server instance. When I try and execute a simple select statement such as "select count(*) from all_objects@sql_server" through OraDeveloper I get an error message "ORA-01002: fetch out of sequence." The statement works fine in the SQL Plus/SQL Plus worksheet.

Thanks

Alexz · Post by **Alexz** » Tue 20 Jan 2009 10:27

We'll fix this problem in the next build.

Alexz · Post by **Alexz** » Fri 15 May 2009 10:15

We are sorry for the delay in answer. We've investigated this problem and found out that you should start the transaction to execute such statements. Use the button "Begin Transaction" on the Connection toolbar or item menu "Begin Transaction" in the Database menu that can start the transaction.