[PHP-DOC] cvs: phpdoc /en/functions oci8.xml From: David Benson (dbenson <email protected>)
Date: 09/17/01

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>