Devart Forums

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

We'll fix this problem in the next build.

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.