SELECT from dB Link - commit/rollback needed

[gopi]

(PL/SQL Developer 6.0.3.893)
Hello,

Every time I am in a SQL window and use a database link in a select statement, I am asked to commit or rollback even if the query is 100% read only. (the commit and rollback icons become unprotected)

ie. select * from table_name@linkname;

why is this ? Can I turn this off ? I poked around for a setting inside the preferences did not immediately locate an option.

Thanks.

 

[Marco Kalter]

Oracle implicitly starts a transaction when you run a query across a database link. The commit/rollback buttons indicate this.

If the query is finished (all records are retrieved), then this implicit transaction is closed by PL/SQL Developer.