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 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"
> attribute only relates to fetching and reading long
> values; it is not involved in inserting or updating
> them.
>
> ... so set $dbh->LongReadLen(32767) before the prepare.
>
> /\
> ||
> Or whatever size you want.
>
>
> On 18-Sep-2002 [EMAIL PROTECTED] wrote:
> > 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";
> >
> > This code works for small size saves. However, when value
> > of $html gets large, the code just hungs.
> >
> > I'd appreciate any ideas.
> > Thank you,
> > Chris Lambrek.
>
> ----------------------------------
> E-Mail: [EMAIL PROTECTED]
> Date: 18-Sep-2002
> Time: 13:49:54
> ----------------------------------
