I am trying to set up a Trigger to put the NEXTVAL of a Sequence into a
field of a table after the other fields have been inserted with data. The
trigger is valid and enabled yet it does not put the NEXVAL in the new row.
The trigger is as follows:
CREATE OR REPLACE TRIGGER "DBA_LOG_USER"."TRIG_DBAS_DBA_ID"
AFTER INSERT ON "DBA_LOG_USER"."DBAS"
BEGIN
UPDATE DBAS
SET DBA_ID = SEQ_DBAS_DBA_ID.NEXTVAL;
END;
Bryan M. Miller
Junior Oracle DBA
IT Operations
Telergy Inc.
Email: bmiller_at_telergy.net
Phone: (315)362-2642
Pager: (315)647-1908
Received on Mon Sep 25 2000 - 10:57:18 CDT
