Page 1 of 1

Oracle 7 : Invalid Blob

Posted: Mon 15 Dec 2008 11:57
by sandrine
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?

Posted: Mon 22 Dec 2008 09:35
by Plash
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.

Posted: Mon 05 Jan 2009 09:01
by sandrine
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.