How to build this specific trigger ?

From: Olivier Utkala <o.utkala_at_hrnet.fr>
Date: Tue, 14 Sep 1999 19:04:03 +0200
Message-ID: <7rlvaj$inb$1@wanadoo.fr>

I need a trigger who incremente automatically the id column of a table. Is this trigger is BEFORE INSERT or AFTER INSERT ? I try some test and I have the returned error : ORA-04098.

The SQL code of one of my test :

CREATE OR REPLACE TRIGGER "MSG".INS_TEST BEFORE INSERT OR UPDATE OF "ID" ON "MSG"."TEST" DECLARE
 new_id INTEGER;
BEGIN
 new_id := select max(id,1) from msg.test;  id := new_id + 1;
END; Thanks for any help.

---

Olivier Received on Tue Sep 14 1999 - 12:04:03 CDT