oci_commit

Description

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

Example 1. oci_commit() example <?php    // Login to Oracle server    $conn = oci_connect('scott', 'tiger');         // Parse SQL    $stmt = oci_parse($conn, "                              INSERT INTO                                          employees (name, surname)                                    VALUES                                          ('Maxim', 'Maletsky')                              ");    /* Execute statement        OCI_DEFAULT tells oci_execute()        not to commit statement immediately */    oci_execute($stmt, OCI_DEFAULT);    /*    ....    Parsing and executing other statements here ...    ....    */       // Commit transaction    $committed = oci_commit($conn);    // Test whether commit was successful. If error occurred, return error message    if (!$committed) {        $error = oci_error($conn);        echo 'Commit failed. Oracle reports: ' . $error['message'];    } ?>

Returns TRUE on success or FALSE on failure.

See also oci_rollback() and oci_execute().