CODEWITHSUNDEEP
phpsqloracle-databasetransactionsrollback
aw crud
aw crud

Reputation: 8891

Should I rollback failed SELECT statements or commit successful ones?

Out of habit I've been using try/catch blocks in my application code for all SQL queries, with a rollback at the beginning of the catch block. I've also been committing those which are successful. Is this necessary for SELECTs? Does it free up something on the database side? The select statements aren't altering any data so it seems somewhat pointless, but perhaps there is some reason I'm not aware of.

e.g.

try {
  $results = oci_execute($statement)
  oci_commit($connection);
  return $results;
}
catch {
  oci_rollback($connection)
  throw new SqlException("failed");
}

Upvotes: 6

Views: 1846

Answers (1)

Quassnoi
Quassnoi

Reputation: 425613

SELECT statements in Oracle (unless they are SELECT FOR UPDATE) never lock any records and never open transactions implicitly.

Unless you issued any DML operations within your transaction, it will not matter whether you commit or roll back your transaction.

Upvotes: 7

Related Questions