Search notes:

Oracle SQL noun: TRANSACTION

SET TRANSACTION

set transaction starts a new transaction and defines some characteristics of this transaction:

Read-only or writable. (Setting the transaction to read only by user SYS is ignored)
Isolation level: serializable or read committed. read committed is the default.
The used rollback segment (ignored if Oracle runs in automatic undo mode)
The name of the transaction. Naming transactions is especially useful in distributed database environments to resolve in-doubt transactions.

The set transaction statement is optional, however, if it is used, it must be the first statement in a transaction.

See also

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1788525682, '216.73.217.21', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/SQL/statement/nouns/transaction/index(46): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78