Re: Triggers and DDL

From: <moerkd_at_my-deja.com>
Date: Fri, 10 Dec 1999 20:53:11 GMT
Message-ID: <82rp7l$fmd$1@nnrp1.deja.com>

In article <82m3kg$ri$1_at_ssauraaa-i-1.production.compuserve.com>, Mark Rommelfanger <m.rommelfanger_at_mercmarine.com> wrote:
> I am writing a trigger that fires after insert. I want to use the
> information inserted to create a temporary table. I was thinking of
using
> the dbms_sql package but when using DDL with dbms_sql it does an
implied
> commit after the prepare executes the statement but commits are not
allowed
> in triggers. Is there another way to accomplish what I want.
>
> Thanks,
>
> Mark
>

Try this

use DBMS_PIPE (asynchron to transactions) or DBMS_ALERT (synchron to transactions) to send a message to a process (dbms_job) whitch makes the Insert for you. As you wanted to use a trigger to make the insert, i think you wanted to do it in a transaction, that means use DBMS_ALERT.

Hope this helps

Deltev

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 10 1999 - 14:53:11 CST