Chapter 3 revealed that the oci_execute()function performs an automatic commit. The PEAR DB
module is a superstructure, on top of database modules which are
already a part of PHP.
The PEAR DB module that works with Oracle is built
by using the oci_execute()
function to execute SQL statements. PEAR DB, therefore, performs an
automatic commit when connected to Oracle RDBMS.
In contrast to the OCI8 module, which is procedural; PEAR DB is object
oriented, and whatever is done with arguments to functions in OCI8 is
performed by methods in PEAR DB.
The automatic commit is turned on or off by using
the autocommit()method in
the DB connection class. This is shown in the following example: