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

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;