Re: Using Triggers and Sequences

On Tue, 24 Mar 1998 12:42:16 -0000, "Mark Powell" <mark_at_u-net.net> wrote:

Mark,

You have to SELECT the next sequence value from dual. Try this:

>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
  ID_NUM NUMBER;
>BEGIN

 SELECT USER.S_AG_NUM.NEXTVAL INTO ID_NUM FROM DUAL;
> :new.AG_NUM := ID_NUM;
>END;
>
>....complains with an error "MGR-00073: Warning: TRIGGER USER.SUBS_TRIG
>created with compilation errors."

Jonathan Received on Wed Mar 25 1998 - 00:00:00 CST