Re: "Execute immediate" in a trigger

> First off COMMIT and ROLLBACK never belong inside a trigger unless the
> trigger is an autonomous transaction. And in case you think using that
> pragma is the solution ... I'd advise you against it.

Thank you, Daniel and Michel.
By now I used a workaround, programmatically, outside the trigger. I'll try the autonomous_transaction pragma to evaluate what solution is better.

Regards Received on Fri Jan 16 2004 - 01:41:59 CST