Help with DBMS_LOB

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? Received on Mon Jun 27 2005 - 12:54:48 CDT