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

Hi,

As a new developer, I am interested in the autonomous transaction mechanism. Currently we are using Oracle 8.0.5, and don't have this functionality.

Is there a way to simulate an autonomous transaction.

TIA. J.

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],[],[],[],[]...
>
>In documentation I couldn't find any limitations or warnings against
>using this pragma in database event triggers. Is this behavior a bug?
>
>Here is a test case:
>
>SQL> connect system/manager_at_o815
>Connected.
>SQL> create or replace trigger
> 2 logon_trigg_test2 after logon on scott.schema
> 3 declare
> 4 pragma autonomous_transaction;
> 5 begin
> 6 insert into test_trigg_table values (sysdate, user);
> 7 commit;
> 8 end;
> 9 /
>
>Trigger created.
>
>SQL> connect scott/tiger_at_o815
>ERROR: ORA-00600: internal error code, arguments: [4450], [], [], [],
>[], [], [], []
>
>
>Warning: You are no longer connected to ORACLE.
>SQL>
>
>TIA,
>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 Fri Oct 08 1999 - 10:49:26 CDT