ocicommit

Description

ocicommit() commits all outstanding statements for the active transaction on Oracle connection connection.

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); ?>

See also ocirollback().