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 SELECT
s? 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");
}