One thing I left off. I changed the Oracle field to a BLOB, replaced OCI_B_CLOB with OCI_B_BLOB, the insert was successful but no data was saved to the BLOB.
Kathy
kkoehler@xxxxxxxxxxx wrote:
> 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
