PHP Manual
Prev |  | Next

# OCICommit

(PHP 3>= 3.0.7, PHP 4 )

OCICommit -- Commits outstanding transactions

## Description

bool OCICommit ( int connection)

OCICommit() commits all outstanding statements for Oracle connection `connection`. Returns `TRUE` on success or `FALSE` on failure.

This example demonstrates how OCICommit is used.

Example 1. OCICommit
    <?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().

Prev | Home | Next
OCIColumnTypeRaw | Up | OCIDefineByName