Heterogeneous select fails

Heterogeneous select fails

Postby 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
gavin01
 
Posts: 1
Joined: Wed 14 Jan 2009 20:24
Location: Warren, MI

Postby Alexz » Tue 20 Jan 2009 10:27

We'll fix this problem in the next build.
Alexz
Devart Team
 
Posts: 165
Joined: Wed 10 Aug 2005 08:30

Postby 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.
Alexz
Devart Team
 
Posts: 165
Joined: Wed 10 Aug 2005 08:30


Return to dbForge for Oracle