PHP 4.3.8/Oracle 9i OCI call question for BLOBs
| From: | kkoehler at comcast dot net | Date: | Wed, 22 Sep 2004 17:24:50 +0000 |
| Subject: | PHP 4.3.8/Oracle 9i OCI call question for BLOBs | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-36344@lists.php.net to get a copy of this message | ||
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