Larger Blob field on Oracle

Zanette · Post by **Zanette** » 30.11.2005, 12:30

I'm using Zeos 6.5.1 on Oracle 10g, Delphi 7, Windows.
I have a XML data with 8Kb that need to be saved on a 'LONG RAW' field.
When I call ZQuery.Post, it saves only 4000 bytes.
In BDE and DOA it works fine.

thanks
Marcelo Zanette

ssamayoa · Post by **ssamayoa** » 17.01.2006, 20:34

I'm investigating this issue since I want to access relative big BLOBs and BFILEs.

Regards.

ssamayoa · Post by **ssamayoa** » 17.01.2006, 22:06

FWIW, I found that LOB and CLOB are fetched and sent back to the database as RAW not with LOB locators.

Increasing the size of LOB and CLOB which can be readed and write is a matter of haking a bit in TZOracleResultSet.Open (I guess that where DBX driver sets its limit) but support for BFILE will be more dificult.

Regards.

rzufall · Post by **rzufall** » 19.09.2006, 14:23

Hi,

i know that the last post is a few month ago, but has someone a
solution for reading BLOB-fields?

I use Oracle9i and I can save the files in the db. But if I read the
blob-fields I also get the error "ORA-01406: fetched column value was truncated"

Thanks,

Rainer