| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: TRIGGER QUESTION- URGENT
Try this:
CREATE OR REPLACE TRIGGER "DBA_LOG_USER"."TRIG_DBAS_DBA_ID"
BEFORE INSERT ON "DBA_LOG_USER"."DBAS"
REFERENCING OLD AS OLD NEW AS NEW
BEGIN
:new.DBA_ID := SEQ_DBAS_DBA_ID.NEXTVAL;
END;
HTH.
Gunawan Yuwono
Oracle DBA
Kansas City, MO
>--- Original Message ---
>From: "Miller, Bryan" <MillerB_at_telergy.net>
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Date: 9/25/00 5:00:27 PM
>
>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
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Miller, Bryan
> INET: MillerB_at_telergy.net
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing
Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).
You may
>also send the HELP command for other information (like subscribing).
>
>
 |
 |