   #PHP Manual Oracle 8 functions ocicolumntyperaw ocidefinebyname

   PHP Manual
   Prev  Next
   ______________________________________________________________________

                                   ocicommit

   (PHP 3>= 3.0.7, PHP 4 )
   ocicommit -- Commits outstanding transactions

Description

   bool ocicommit ( resource connection)

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

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

   See also ocirollback().
   ______________________________________________________________________

   Prev             Home            Next
   ocicolumntyperaw  Up  ocidefinebyname
