Re: Help with DBMS_LOB

alex 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?

Oracle version and edition? Unknown?
What you were trying to do? Unknown?
The PL/SQL involved? Unknown?

Generic advice: End your session.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)