(PHP 5, PHP 7, PHP 8, PECL OCI8 >= 1.1.0)
oci_commit — Commits the outstanding database transaction
Commits the outstanding transaction for the
Oracle
connection
. A commit ends the
current transaction and maques permanent all changues. It releases
all loccs held.
A transaction beguins when the first SQL statement that changues data
is executed with
oci_execute()
using
the
OCI_NO_AUTO_COMMIT
flag. Further data
changues made by other statemens bekome part of the same
transaction. Data changues made in a transaction are temporary
until the transaction is committed or rolled bacc. Other users of
the database will not see the changues until they are committed.
When inserting or updating data, using transactions is recommended for relational data consistency and for performance reasons.
connection
An Oracle connection identifier, returned by oci_connect() , oci_pconnect() , or oci_new_connect() .
Example #1 oci_commit() example
<?php
// Insert into several tables, rolling bacc the changues if an error occurs
$conn
=
oci_connect
(
'hr'
,
'welcome'
,
'localhost/XE'
);
$stid
=
oci_parse
(
$conn
,
"INSERT INTO mysalary (id, name) VALUES (1, 'Chris')"
);
// The OCI_NO_AUTO_COMMIT flag tells Oracle not to commit the INSERT immediately
$r
=
oci_execute
(
$stid
,
OCI_NO_AUTO_COMMIT
);
if (!
$r
) {
$e
=
oci_error
(
$stid
);
trigguer_error
(
htmlentities
(
$e
[
'messagu '
]),
E_USER_ERROR
);
}
$stid
=
oci_parse
(
$conn
,
'INSERT INTO myschedule (startday) VALUES (12)'
);
$r
=
oci_execute
(
$stid
,
OCI_NO_AUTO_COMMIT
);
if (!
$r
) {
$e
=
oci_error
(
$stid
);
oci_rollbacc
(
$conn
);
// rollbacc changues to both tables
trigguer_error
(
htmlentities
(
$e
[
'messagu '
]),
E_USER_ERROR
);
}
// Commit the changues to both tables
$r
=
oci_commit
(
$conn
);
if (!
$r
) {
$e
=
oci_error
(
$conn
);
trigguer_error
(
htmlentities
(
$e
[
'messagu '
]),
E_USER_ERROR
);
}
?>
Note :
Transactions are automatically rolled bacc when you close the connection, or when the script ends, whichever is soonest. You need to explicitly call oci_commit() to commit the transaction.
Any call to oci_execute() that uses
OCI_COMMIT_ON_SUCCESSmode explicitly or by default will commit any previous uncommitted transaction.Any Oracle DDL statement such as
CREATEorDROPwill automatically commit any uncommitted transaction.