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

No, because if there had been a way, Oracle wouldn't have had to create autonomous transactions in the first place :-)

I don't think you'll have any choice but to upgrade to 8.1.5 or higher if you want to use this feature.

Jason Wright <wrightja_at_gov.on.ca> wrote in message news:7tl3tu$e0g$1_at_news.gov.on.ca...
> 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 - 13:07:27 CDT