PHP 4.3.8/Oracle 9i OCI call question for BLOBs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I'm trying to write text to a BLOB.  I got a valid return code but it did not write the BLOB.  I was able to use similar code writing to a CLOB.  Any examples I've seen for BLOBs are reading from Binary files.  Here's how I did the CLOB, but it would not work for BLOB.  Is this a bug in PHP?

$query = "insert into " . getSchema() . "attf_description " .
    "(id, narticid, nordertoprint, vheadertoprint, cldescription ) " . 
         " values(" .
   $id . ", " . $articid . ", " . $ordertoprint . ",'"  . $headertoprint . "', EMPTY_CLOB()) "
   . "returning CLDESCRIPTION into :CLDESCRIPTION";

 $parsed = ociparse($connection,$query);
 $clob = OCINewDescriptor($connection, OCI_D_LOB);
 $bind = OCIBindByName($parsed, $clob_name, $clob, -1, OCI_B_CLOB);
 ociexecute($parsed, OCI_DEFAULT);
  $err = $clob->save($clob_data);
  $committed = ocicommit($connection, OCI_DEFAULT);
   OCIFreeStatement( $parsed );

Thanks,
Kathy

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux