Hi Marco. Hope you received my demo project ok.

Any ideas?

Thanks
Christopher

I did receive it, but have not yet been able to reproduce the problem. The program runs successfully. I will try it on some other configurations.

Can you let me know your client and server version?

Hello Marco, thanks for the feedback.

I'm using Delphi 5 with DOA 4.0.5
Oracle server version 9.2.0.4.0
Oracle client version 9.2.0.1.0
All on Windows NT 4 platform.

Okay, I will try a similar configuration.

Hi Marco. Any update?

No luck yet.

Marco
Can you let me know what configuration you used that works okay?
This may help us.
Regards
Christopher

I have successfully tested it on a 9.0 and 10g server, but I have been able to reproduce it on a 9.2.0.4 server. I actually get an ORA-22922 error (nonexistent LOB value). This happens when the LOB Locator is freed. The only workaround I can think of at the moment is to ignore the error in TLOBLocator.Free.

Thanks Marco.

We hope to upgrade to 9.2.0.5 soon. Have you tried that version?

If it is specific to certain Oracle versions, maybe that will solve it.

However, if it is an Oracle bug, I am unsure how to raise this with Oracle, as I cannot see a way to reproduce the error without using DOA.

I am currently using that work around. However, our application is an IIS app, and it appears to be leaking memory. This problem seems to be prime candidate.

Any further suggestions welcome.

Regards
Christopher

I have not tried 9.2.0.5, but I will give that a try too.

The error will most likely cause a memory leak, since the OCI handle for the LOB Locator is not freed.