I'm new to what seems to be an old problem. But since this discussion
has happened, is there a chance Oracle as addressed the problem?

The current release for the Oracle JDBC driver is 9.2.0.5. But even as
early as 9.2.0.3, the release notes say a bug was fixed for:

"ORACLE.SQL.CLOB.CREATETEMPORARY CREATES LEAK OF TEMP LOBS IN SERVER"
It is referenced as bug number 2723384 , but I can't turn up any more
details.

It seems to me using any of the new drivers should fix this problem. Or
is use of the interceptor still required for leaks?



>>I am using the JDBC driver 9.2.0.3.0 and found within the
>>documentation the siganture:
>>  createTemporary(java.sql.Connection conn, boolean cache, int
>>duration)
>>Duration can be DURATION_CALL and DURATION_SESSION.
>>Is DURATION_CALL the solution?

>>Sorry for posting twice, but it was not in the right thread.

.