Re: Re: Can't save oracle BLOB with DBI::Oracle

2002-09-19 Thread akis100
On 9/18/2002 16:29:15, you said: LongReadLen only applies to _reading_ LONGs and LOBs, not writing to them. That's right. And in anycase, I had this set to 1M. After doing some experimentation, it turns out that this is a problem with the Oracle database, not ora perl. This we concluded

Re: Can't save oracle BLOB with DBI::Oracle

2002-09-19 Thread Tim Bunce
FYI: LongReadLen only applies to reading longs from the database (Long*Read*Len). It doesn't apply to placeholders. Tim. On Wed, Sep 18, 2002 at 01:52:22PM -0500, [EMAIL PROTECTED] wrote: LongReadLen (unsigned integer, inherited) This attribute may be used to control the

Re: Can't save oracle BLOB with DBI::Oracle

2002-09-19 Thread shildreth
Sorry, I skimmed the email to fast, I didn't notice you were updating the db. STH On 18-Sep-2002 Michael A Chase wrote: On Wed, 18 Sep 2002 13:52:22 -0500 (CDT) [EMAIL PROTECTED] wrote: LongReadLen (unsigned integer,

Can't save oracle BLOB with DBI::Oracle

2002-09-18 Thread akis100
Hello, I am using the following code to update a BLOB field into our Oracle database: $sql = UPDATE CMSDOCUMENT SET CONTENT=? WHERE CMSDOCUMENTID=$cmsid; $sth = $oradbh-prepare($sql); $sth-bind_param(1, $html, {ora_type = ORA_BLOB}); $sth-execute() or die update of topic content failed.\n;

RE: Can't save oracle BLOB with DBI::Oracle

2002-09-18 Thread shildreth
LongReadLen (unsigned integer, inherited) This attribute may be used to control the maximum length of long fields (blob, memo, etc.) which the driver will read from the database automatically when it fetches each row of data. The LongReadLen

Re: Can't save oracle BLOB with DBI::Oracle

2002-09-18 Thread Michael A Chase
On Wed, 18 Sep 2002 12:24:52 -0500 [EMAIL PROTECTED] wrote: I am using the following code to update a BLOB field into our Oracle database: $sql = UPDATE CMSDOCUMENT SET CONTENT=? WHERE CMSDOCUMENTID=$cmsid; $sth = $oradbh-prepare($sql); $sth-bind_param(1, $html, {ora_type = ORA_BLOB});