Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using Triggers and Sequences
"Mark Powell" <mark_at_u-net.net> wrote:
>CREATE OR REPLACE TRIGGER USER.SUBS_TRIG
>BEFORE INSERT OR UPDATE OF AG_NUM ON USER.E_SUBS
>FOR EACH ROW
>WHEN (new.AG_NUM = 0 )
>BEGIN
> :new.AG_NUM := USER.S_AG_NUM.NEXTVAL;
>END;
>
>Any help would be gratefully appreciated (as I'm pulling my hair out!)
>
Try:
CREATE OR REPLACE TRIGGER USER.SUBS_TRIG
BEFORE INSERT OR UPDATE OF AG_NUM ON USER.E_SUBS
FOR EACH ROW
WHEN (new.AG_NUM = 0 )
declare
v_seq number;
BEGIN
select user.s_ag_num.nextval into v_seq from dual; :new.AG_NUM := v_seq;
-- Remove the "x" to reply.Received on Tue Mar 24 1998 - 00:00:00 CST