Problems with ODAC 7.20.0.8 for Delphi 7 and Securefiles

Power · Post by **Power** » Mon 14 Nov 2011 14:15

Hi,

Our Software is saving zipped documents in a blob-Field in the Oracle 11g Database. Now we started to use the new feature Securefiles from Oracle for blob-Fields. But after loading the documents from the Database again, we are getting an error by the attemp to unzip the document. The archive appears to be corrupt. The problem occurs not for all documents, maybe a matter of size. One important thing you should know too, the size of the again loaded archives are bigger than before.

Further Informations:

OS: AIX
Database: Oracle 11g (11.2.0.2.0)
Test-document: e15887.pdf (Oracle document file)

Hopefully you can reproduce and fix the error.

Kind Regards

Power

Power · Post by **Power** » Wed 16 Nov 2011 11:50

Hi,

is there any solution in sight?

AlexP · Post by **AlexP** » Wed 16 Nov 2011 14:38

Hello,

I checked how ODAC works with SecureFile, and all data are written/read without any errors. I checked this with files of ~ 150 Mb size. Please try to reproduce this problem with ODAC version 8.0.2 and specify the size of the files you encountered problems with.