Since rBuffer is Raw(1024) it reads this amount in every fetch untill
last iteration when it fetches lesser than this. By observing the
"amt" value i have verified it. I have tried the variant suggested by
you but its still the same.
There is a pattren i have observed. Every odd read returns junk value
while even returns correct value!
Harald Maier <maierh_at_myself.com> wrote in message news:<m31xvcygoq.fsf_at_ate.maierh>...
> vashisht_r_at_yahoo.com (Neo) writes:
>
> > Hi All,
> > I am trying to read blobs through Pro*c code. When the blob value is
> > read within on shot it works fine but the moment my code tries to get
> > this value by polling it gives absurd results. Mostly it returns junk
> > values in alternate retrieves.
>
> How much bytes should the statement read?
>
> EXEC SQL AT :connectStr LOB READ :amt FROM :readBlob INTO :rBuffer;
>
> You may try the following variant:
>
> EXEC SQL AT :connectStr LOB READ :amt FROM :readBlob INTO :rBuffer
> WITH LENGTH :rBufferSize;
>
> Harald
Received on Mon Aug 25 2003 - 00:06:24 CDT
