triggering row deleted

Hi there,

I have a message table M (seq#, msg_body). I have a trigger TM attached to this table

        TRIGGER TM after insert on M for each row. The trigger processes the msg_body.
After processing I need to delete this row.

Currently, the trigger TM generates an ALERT A(seq#) and a procedure P (that has to be already started) waits for that alert. Once P receives A(seq#), it deletes the row with seq# from M.

Any idea about a more straitforward solution? Can I delete the triggering row directly from the trigger itself? How?

Thanks.

Jozef Received on Wed Jul 12 1995 - 00:00:00 CEST