"Execute immediate" in a trigger

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 Received on Thu Jan 15 2004 - 10:49:08 CST