maxim Sat Nov 9 19:26:04 2002 EDT
Modified files:
/phpdoc/en/reference/oci8/functions ocicommit.xml
Log:
Expanded documentation with return values, useful example and "see also"
Index: phpdoc/en/reference/oci8/functions/ocicommit.xml
diff -u phpdoc/en/reference/oci8/functions/ocicommit.xml:1.2
phpdoc/en/reference/oci8/functions/ocicommit.xml:1.3
--- phpdoc/en/reference/oci8/functions/ocicommit.xml:1.2 Wed Apr 17 02:42:18
2002
+++ phpdoc/en/reference/oci8/functions/ocicommit.xml Sat Nov 9 19:26:04 2002
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.2 $ -->
+<!-- $Revision: 1.3 $ -->
<!-- splitted from ./en/functions/oci8.xml, last change in rev 1.2 -->
<refentry id="function.ocicommit">
<refnamediv>
@@ -14,8 +14,44 @@
</methodsynopsis>
<para>
<function>OCICommit</function> commits all outstanding statements
- for Oracle connection <parameter>connection</parameter>.
+ for Oracle connection <parameter>connection</parameter>.
+<function>OCICommit</function>
+ returns &true; on success and &false; otherwise.
</para>
+ <para>
+ This example demonstrates how OCICommit is used.
+ <example>
+ <title>OCINLogon</title>
+ <programlisting>
+<![CDATA[
+<?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);
+?>
+]]>
+ </programlisting>
+ </example>
+ </para>
+ <simpara>
+ See also <function>OCIRollback</function>.
+ </simpara>
</refsect1>
</refentry>
--
PHP Documentation Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
