On Wed, 8 Nov 2006 23:26:02 -0800, Jonathan Leffler wrote:
>>And 2), in a fetch loop, is it possible to adjust a property like
>> {ReadLongLen}, and retry the same fetch without restarting the whole
>> loop? Because this error typically happened several minutes into the
>> loop.
>
>
>Highly unlikely. The data has been fetched - and truncated. There's not
>usually a way to refetch the same row - unless you have a scroll cursor, and
>DBI doesn't have support for those.
I can see that. Well I'm thinking of the following solution next:
retrieve extra data to identify the row that went wrong and collect
them, keep going on with the rest of the records, and individually fetch
the previously failed ones afterwards.
After a failure, I can go on with the next records, can't I? And
changing ReadLongLen, is that acceptable for the remainder of the loop?
--
Bart.
