2 Replies Latest reply: Aug 5, 2012 9:19 AM by dm48 RSS

    sqldeveloper causing transaction locks with select statement

    dm48
      I'm having an issue where a programmer using sql developer ver 3.0.04, and running a simple select statement from a view:

      select * from fulfillment_report_vw where group_id > 1600;

      This statement causes a lock of a lock type transaction mode held Exclusive. (I tried to copy the output table but it wouldn't copy).

      I don't understand why a select statement would cause a lock.

      Any ideas?

      TIA

      Dave