title: Why do I get an open transaction when just selecting from a database View?
body: <p>If I execute a simple select statement in pl/sql developer against a database table, I get a standard set of results back as I would expect.</p>
  
  <p>Recently, I pasted a query from a stored procedure that happened to select from a view, and noticed that a transaction was seemingly left open. This was appraent by the rollback and commit options were available in PL/SQL developer.</p>
  
  <p>A poll of other developers revealed that this seems to affect some but not others, which lead me to suspect PL/SQL Developer settings.</p>
  
  <p>Why on earth would this be the case? The view itelf has a DBLink to another database, but I wouldn't expect this to have any effect. </p>
  
  <p>Any thoughts?</p>