Re: Autonomous transaction in database event triggers

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 7 Oct 1999 10:15:11 +0100
Message-ID: <939288159.24594.0.nnrp-11.9e984b29@news.demon.co.uk>

That's what I'd call a stroke of genius.

I feel very twitchy about logon/startup etc. triggers for exactly the experience you found - what if they go wrong and no-one can connect every again. So I'll second your idea of having a scratch database that can be thrown away at the drop of a hat. In fact I have advised people to buy a small Sun or HP to run as a standalone one-horse database server for exactly such tests.

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

> So finally when I have already
given up
>all the hopes and was preparing to recreate the database (it is only a
>testing instance, thank god), I tried with the last shot in the dark:
>
>DECLARE
> PRAGMA autonomous_transaction;
>BEGIN
> EXECUTE IMMEDIATE 'DROP TRIGGER trigger_name';
>END;
>
>And guess what - it succeeded, the trigger was dropped and I was able
>to log on normally again.
>
Received on Thu Oct 07 1999 - 04:15:11 CDT

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