cvs: phpdoc /en/functions oci8.xml

From: Date: Mon, 17 Sep 2001 20:55:19 +0000
Subject: cvs: phpdoc /en/functions oci8.xml
Groups: php.doc 
Request: Send a blank email to phpdoc+get-969337605@lists.php.net to get a copy of this message
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>

« previous php.doc (#969337605) next »