Re: Autonomous transaction in database event triggers - a bug?

From: Jurij Modic <jmodic_at_src.si>
Date: Thu, 07 Oct 1999 22:55:30 GMT
Message-ID: <380224be.6414099@news.arnes.si>

On Thu, 07 Oct 1999 19:29:50 GMT, "Kevin P. Fleming" <kfleming_at_access-NOSPAM-laserpress.com> wrote:

>According to the Oracle 8i docs, any errors caused by logon triggers will
>cancel the login attempt, unless you are logging in as SYSTEM. Don't know
>about startup triggers though, I assume there are similar fallbacks in place
>so the database can at least come up in restricted session mode.

Well, the documentation says this about errors trapped by *predefined or user defined exceptions*. In my case I was getting ORA-3113 or ORA-600, which I believe can't be trapped, not even with "WHEN OTHERS" exception.

Anyway, I just tested it with my offending LOGON triggers and it resulted in either ORA-3113 or ORA-600, even though they were defined on schema SYSTEM and I was trying to log on as SYSTEM.

Thanks anyway,

Jurij Modic <jmodic_at_src.si>
Certified Oracle DBA (7.3 & 8.0 OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Thu Oct 07 1999 - 17:55:30 CDT