ORACLE 8 & Blob's Field >>> invalid blob handle in record buffer

[Adrian Lorenzo]

Hi!

Im Using Oracle 8 with . BDE 5.1. with D3.02.
when trying navigate trougth a query i get 'invalid blob handle in record
buffer'
why??????

thanks in advance

sorry mi bad english

A. Lorenzo

[dav...@carecentric.com]

> Im Using Oracle 8 with . BDE 5.1. with D3.02.
> when trying navigate trougth a query i get 'invalid blob handle in
record
> buffer'
> why??????

Blobs are cached by BDE. In a large result set, you will receive this
error if iterating the result set that scanning back to beginning.

There is a setting in BDE configuration for Blobs To Cache (may also be
in your TDatabase instance if you selected defaults). The default for
this is 64, which means you can iterate up to 64 rows, but if you reach
65 and attempt to go back to 1 your blob is no longer cache.

The ways we worked around this:
1. Set Blobs To Cache to maximum value 65535
2. Modify the query to not return blobs in the result set. When it came
time to evaluate or view the blob, would execute another query to
retrieve it "on demand".

Hope this helps out.
Dave.

Sent via Deja.com http://www.deja.com/
Before you buy.

[Dave Stockton]

Can't reply to Oracle 8 & BDE, but we had problem with SQL Anywhere 5.5.04
and BDE 5.

There is a setting in the BDE configuration called Blobs To Cache which
defaults to 64. If your result set returns more than this and you iterate
through the list then back to the first one you will get the dreaded
"Invalid Blob Handle in Record Buffer" exception.

What we ended up doing is setting the Blobs To Cache setting to its maximum
value of 65535. Other instances we executed
queries to retrieve the blob on demand (i.e. user selected record 9,
retrieve the blob associated to record 9).

Hope this helps.

Adrian Lorenzo <alor...@ceni.com.ar> wrote in message
news:88ca67$kf...@bornews.borland.com...
> Hi!

>
> Im Using Oracle 8 with . BDE 5.1. with D3.02.
> when trying navigate trougth a query i get 'invalid blob handle in record
> buffer'
> why??????
>

[Adrian A. Lorenzo]

Dave,
this parameter work fine with sql server, sybase, informix, etc, but
oracle ignore the blobs to cache settings......oracle or bde bug?....
Borland say: 'is a bugs of Oracle Client'

tnk you

A. Lorenzo

Dave Stockton escribió en mensaje <88e937$lf...@bornews.borland.com>...

[dav...@carecentric.com]

> Dave,
> this parameter work fine with sql server, sybase, informix, etc,
but
> oracle ignore the blobs to cache settings......oracle or bde bug?....
> Borland say: 'is a bugs of Oracle Client'

That is very strange as I thought it was a BDE setting independent of
the database engine.

I cannot tell you today if it is a bug or not, but would be able to
tell you within a couple of days as we are currently migrating from
Sybase SQL Anywhere to Oracle 8.1.5/Oracle Lite and dealing with MANY
other issues with regards to BDE and Oracle.

[Laurent Birckel]

I have another case where I get the "Invalid Blob Handle"

It's where the Blob field is got by a Query, and where the ':' sign is include
in the Blob . In this case, I get some troubles.

I don't know if this will help you, but if you have an idea to help me ....

Laurent

"Adrian A. Lorenzo" a écrit :

> Dave,
> this parameter work fine with sql server, sybase, informix, etc, but
> oracle ignore the blobs to cache settings......oracle or bde bug?....
> Borland say: 'is a bugs of Oracle Client'
>