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 after we restarted the database and the
code run fine. Our DBA is currently working with Oracle
support on this as they also agreed that this is a problem
with Oracle..
>On Wed, 18 Sep 2002 13:52:22 -0500 (CDT) [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.
>
>LongReadLen only applies to _reading_ LONGs and LOBs, not writing to them.
>
>--
>Mac :})
>** I normally forward private questions to the appropriate mail list. **
>Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html
>Give a hobbit a fish and he eats fish for a day.
>Give a hobbit a ring and he eats fish for an age.
>
>
>
