ocicommit
(PHP 3>= 3.0.7, PHP 4 , PHP 5)
ocicommit -- Commits outstanding transactions
Description
bool
ocicommit ( resource connection )
ocicommit() commits all outstanding statements
for the active transaction on Oracle connection connection.
Returns TRUE on success or FALSE on failure.
This example demonstrates how ocicommit() is used.
Example 1. ocicommit() example
<?php // Login to Oracle server $conn = OCILogon('scott', 'tiger'); // Parse SQL $stmt = OCIParse($conn, "INSERT INTO employees (name, surname) VALUES ('Maxim', 'Maletsky')");
// Execute statement OCIExecute($stmt);
// Commit transaction $committed = OCICommit($conn);
// Test whether commit was successful. If error occurred, return error message if (!$committed) { $error = OCIError($conn); echo 'Commit failed. Oracle reports: ' . $error['message']; }
// Close connection OCILogoff($conn); ?>
|
|
Note:
This function was renamed to oci_commit()
after PHP >= 5.0.0. For downward compatibility
ocicommit() can also be used.
This is deprecated, however.
See also ocirollback().