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

You don't need to declare an autonomous transaction for an AFTER LOGON trigger. Check the SQL manual about 10 pages into the bit on triggers.

The content of any DDL-based triggers automatically starts an autonomous transaction, executes your code and commits.

Of course, this doesn't mean that your redundant
> 4 pragma autonomous_transaction;

should cause an ora-00600, but it does bypass the problem,

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Jurij Modic wrote in message <37f7cd8d.7356791_at_news.siol.net>...
>Oracle 8i, release 8.1.5, NT4.0 SP4.
>
>I'm experimenting with new database event triggers, more specifically
>with AFTER LOGON trigger.
>
>Whenever I try to use PRAGMA AUTONOMOUS_TRANSACTION in this type of
>trigger, the trigger compiles OK, but when a user tries to connect,
>this trigger causes ORA-600 with arguments [4450],[],[],[],[]...
>
Received on Mon Oct 04 1999 - 15:53:51 CDT