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

[Sterling Hughes]

sterling                Sun May  6 18:35:02 2001 EDT

  Modified files:              
    /phpdoc/en/functions        oci8.xml 
  Log:
  Fix OCINewDescriptor() example
  
  
Index: phpdoc/en/functions/oci8.xml
diff -u phpdoc/en/functions/oci8.xml:1.19 phpdoc/en/functions/oci8.xml:1.20
--- phpdoc/en/functions/oci8.xml:1.19   Sat May  5 21:42:23 2001
+++ phpdoc/en/functions/oci8.xml        Sun May  6 18:35:01 2001
@@ -260,7 +260,13 @@
   records just after the insert.
 */
 
-$conn = OCILogon("scott","tiger");
+$conne {
+     // $lob_upload contains the temporary filename of the uploaded file
+     $conn = OCILogon($user, $password);
+     $lob = OCINewDescriptor($conn, OCI_D_LOB);
+     $stmt = OCIParse($conn,"insert into $table (id, the_blob) 
+               values(my_seq.NEXTVAL, EMPTY_B
+= OCILogon("scott","tiger");
 
 $stmt = OCIParse($conn,"insert into emp (empno, ename) ".
                                           "values (:empno,:ename) ".
@@ -769,7 +775,7 @@
      $stmt = OCIParse($conn,"insert into $table (id, the_blob) 
                values(my_seq.NEXTVAL, EMPTY_BLOB()) returning the_blob into 
:the_blob");
      OCIBindByName($stmt, ':the_blob', &$lob, -1, OCI_B_BLOB);
-     OCIExecute($stmt);
+     OCIExecute($stmt, OCI_DEFAULT);
      if($lob->savefile($lob_upload)){
         OCICommit($conn);
         echo "Blob successfully uploaded\n";