Re: "Execute immediate" in a trigger

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 15 Jan 2004 19:00:55 +0100
Message-ID: <4006d4f9$0$28680$626a54ce@news.free.fr>

"NoName" <nobody_at_nowhere.com> a écrit dans le message de news:bu6fv7$8eo$1_at_fata.cs.interbusiness.it...
> Hello,
>
> is it possible to write an 'execute immediate' command inside a "create
> trigger after insert" ?
> Oracle answers with a "ORA-04092: cannot COMMIT or ROLLBACK in a trigger",
> even if I do not explicitily commit anything, and it seems it is caused by
> the 'execute immediate' statement I wrote.
>
> The statement is a 'create or replace view'.
>
> Thanks
>

Yes, it is possible to use "execute immediate" in a trigger No, it is not possible to use it for a DDL statement in a trigger unless you use an autonomous_transaction pragma.

Regards
Michel Cadot Received on Thu Jan 15 2004 - 12:00:55 CST