On 13 Dec 2003 16:17, bd wrote:

>On 05 Dec 2003 16:21, yvanhess wrote:


>It's simple, but making it work in your environment might not be. You
>need to execute this statement after you're done with the CLOB:
>---
>oracle.sql.CLOB.freeTemporary(temporaryClob);
>---

If you are going to implement this (on any appserver), try to do some
load-tests to check if there is a memory leak. I just found out that
with my approach WebLogic leaks prepared statements. If I find a way to
correct this, I'll try to post complete mapper on the main page.