Re: Error while reading blob from database with Pro*c code

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 Sat Aug 23 2003 - 09:30:13 CEST