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. Returns TRUE on success or FALSE on failure.

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

Note: 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().

Hosting by: Hurra Communications Ltd.
Generated: 2007-01-26 18:00:09