Re: Help with DBMS_LOB

On Tue, 28 Jun 2005 01:54:48 +0800, "alex" <whocare_at_s.org> wrote:

>I am learning the DBMS_LOB.
>
>After I've opened a BLOB in my anonymous block, I tried to do something on
>it that resulted in an exception. My close wasnt executed. I fixed the
>error, retry, encountered more exceptions, re-fixed it. Finally, it says:
>
>ORA-22290: operation would exceed the maximum number of opened files or LOBs
>
>It seems that I have missed the close too many times.
>
>My question is: Is there any ways to view and close all the files that I
>have open in my session for far?
>

A bit of RTFM learns there is a DBMS_LOB.FILECLOSEALL procedure. As you didn't post any code you are struggling with (which you should have done) I assume this will help you.

--
Sybrand Bakker, Senior Oracle DBA