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. Возвращает TRUE в случае успешного завершения, FALSE в случае возникновения ошибки.

This example demonstrates how ocicommit() is used.

Пример 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);
?>

Замечание: 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().


HIVE: All information for read only. Please respect copyright!
Hosted by hive КГБ: Киевская городская библиотека