Oracle 7 : Invalid Blob

sandrine · Post by **sandrine** » Mon 15 Dec 2008 11:57

Delphi 7
Oracle client 7.3.4
Oracle server 7.3
ODAC 6.70.0.43

I've got "Invalid blob" message when opening a query with several long and memo fields with option LongStrings set to false.

I sent an example project of my problem to ODAC one month ago but I haven't received any response yet. Are you working on this?

Plash · Post by **Plash** » Mon 22 Dec 2008 09:35

We could not reproduce the problem with your example. The query in your example returns no rows. Maybe you should change the example to return some rows to reproduce the problem.

sandrine · Post by **sandrine** » Mon 05 Jan 2009 09:01

Have you executed TestBlobs.sql file before opening the project ? this file contains data to insert in odac_long, odac_long_char and crgrid_test tables in order to reproduce the problem.
Maybe you should delete existing rows in these tables before inserting new ones.

Regards.