Get an error pulling BLOB from DB. A query with LOB's requires OCI8 mode, but OCI7 mode is used.

[John P]

I recently upgraded my operating system here in the office and needed to reinstall Delphi 7.0 and DOAD7. Since reinstalling the software and rebuilding our components, I can no longer pull BLOB reports from our database. Can someone please provide some insight into fixing this issue? Thanks,

John P

 

[Marco Kalter]

What exactly goes wrong? Any error messages?

 

[John P]

"A query with LOB's requires OCI8 mode, but OCI7 mode is used" is the error message I get. I know that it is something simple but unfortunately cannot remember what the fix was in the past...thanks for any help you can provide...

 

[Marco Kalter]

Are you perhaps using Direct Oracle Access 3.4 or earlier? Oracle10g and later requires Direct Oracle Access 4.x.

 

[John P]

It looks like that is the issue Marco. My company has a license for the new version but unfortunately I cannot locate the license or the install package. My PC was recently reimaged and all I have is the old version and one available.

I installed the component my co-worker built for a different release and his dll works properly.

I will email you directly with my company specific information.

Thanks,

John