[PHP-DOC] cvs: phpdoc /en/functions oci8.xml

[David Benson]

dbenson         Mon Sep 17 16:55:19 2001 EDT

  Modified files:              
    /phpdoc/en/functions        oci8.xml 
  Log:
  Document temporary lob support (dbenson).
  
  
Index: phpdoc/en/functions/oci8.xml
diff -u phpdoc/en/functions/oci8.xml:1.31 phpdoc/en/functions/oci8.xml:1.32
--- phpdoc/en/functions/oci8.xml:1.31   Sun Aug 19 07:47:42 2001
+++ phpdoc/en/functions/oci8.xml        Mon Sep 17 16:55:19 2001
@@ -1,5 +1,5 @@
 <?xml encoding="iso-8859-1"?>
-<!-- $Revision: 1.31 $ -->
+<!-- $Revision: 1.32 $ -->
  <reference id="ref.oci8">
   <title>Oracle 8 functions</title>
   <titleabbrev>OCI8</titleabbrev>
@@ -782,6 +782,36 @@
      OCIFreeStatement($stmt);
      OCILogoff($conn);
   }
+?>
+     </programlisting>
+    </example>
+    <example>
+     <title>OCINewDescriptor</title>
+     <programlisting>
+&lt;?php   
+    /* Calling PL/SQL stored procedures which contain clobs as input
+     * parameters (PHP 4 >= 4.0.6). 
+     * Example PL/SQL stored procedure signature is:
+     *
+     * PROCEDURE save_data
+     *   Argument Name                  Type                    In/Out Default?
+     *   ------------------------------ ----------------------- ------ --------
+     *   KEY                            NUMBER(38)              IN
+     *   DATA                           CLOB                    IN
+     *
+     */
+
+    $conn = OCILogon($user, $password);
+    $stmt = OCIParse($conn, "begin save_data(:key, :data); end;");
+    $clob = OCINewDescriptor($conn, OCI_D_LOB);
+       OCIBindByName($stmt, ':key', $key);
+       OCIBindByName($stmt, ':data', $clob, -1, OCI_B_CLOB);
+       $clob->WriteTemporary($data);
+       OCIExecute($stmt, OCI_DEFAULT);
+       OCICommit($conn);
+       $clob->close();
+       $clob->free();
+       OCIFreeStatement($stmt);
 ?>
      </programlisting>
     </example>