Re: ORA-04068 on New Session

On 1/10/24 15:00, Sayan Malakshinov wrote:
> Iirc, this kind of errors must be passed to a client side or
> explicitly reset their state using DBMS_SESSION.RESET_PACKAGE. So,
> just always use "raise" in "when others then". Don't ignore them and
> do not replace them with raise_application_error

Once upon a time, probably 15 or so years ago, Tom Kyte was railing against "WHEN OTHERS THEN NULL" idiom on one memorable NYOUG session. I see that people are still trying to ignore exceptions, even to this very day.

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

--
http://www.freelists.org/webpage/oracle-l