ocicommit

Manual PHP

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. Returnează TRUE în caz de succes, FALSE în caz contrar.

This example demonstrates how ocicommit() is used.

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

Notã: This function was renamed to oci_commit() after PHP >= 5.0.0. For downward compatibility ocicommit() can also be used. This is deprecated, however.

ocicommit

Description

Ultimele discutii in forum

Ultimele articole

Membri recenti

Top membri

Newsletter

Parteneriat