Re: ORA-04068 on New Session

Mladen,

Obviously, developers read it, but they still often use something like When others then
  Logging... ;
  Raise_application_error(-20xxx, 'human readable error text')

But in such cases, it brings a lot of different problems

On Thu, Jan 11, 2024, 00:55 Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> 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-1217https://dbwhisperer.wordpress.com
>
>

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