Commit icons on select on dblink tables

[dom999v]

Not really a bug, but if I do a select on a remote table e.g. select sysdate from dual@remotedb, then the commit/rollback icons are activated in the toolbar. My current version is 5.0.1.480 but its been there for the last few versions at least.

Thanks

Dom

 

[Marco Kalter]

The Oracle Server starts a transaction when you select across a database link. The toolbar buttons reflect this.

Maybe we can detect this (a select statement that starts a transaction) and implicitly commit it.

------------------
Marco Kalter
Allround Automations

 

[dom999v]

Thanks for the info, and interesting to know that Oracle starts a transaction when you select over a db link.

 

[Harry MacDonald]

Has this been added to your enhancements list (I don't see it addressed in the 6.0 beta)?

I learned today that until you commit or rollback the cross-database transaction, you have a rollback segment tied up on the database, even though there is nothing to rollback.

Thanx,
HMD

 

[Marco Kalter]

It has not yet been added, but it is still planned for the final 6.0 release.

 

[BWendling]

Hi Marco,

is this feature already implemented in 6.0.5 (and in which option)?

Thank you.

 

[Marco Kalter]

This has been implemented, but the implicit transaction cannot be committed until all records are fetched. Otherwise you can get "ORA-01002 Fetch out of sequence" when subsequent records are fetched.

Therefore, if you select records across a database link and not all records have been fetched yet, the commit and rollback buttons will be enabled.