Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: using sequence in a trigger
you forgot FROM DUAL !!
Olivier Régis
MCSE+I, OCP
<ccyr6798_at_my-deja.com> wrote in message news:7uo3kn$ogb$1_at_nnrp1.deja.com...
> I want to use a sequence (met_id_seq) for a unique id (met_id) on a
> table. I'd like to have an insert trigger take care of that column for
> me...
>
> create or replace trigger ml_metlab_trg
> before insert or update or delete on ml_metlab
> referencing new as new old as old
> for each row
> begin
> if inserting then
> :new.met_id := met_id_seq.nextval;
> end if;
> :
> :
>
> But I get an error when creating the trigger.
> PLS-00357: Table,View Or Sequence reference 'MET_ID_SEQ.NEXTVAL' not
> allowed in this context
>
> what am I missing?
> Thanks,
> Cary
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Oct 29 1999 - 02:17:54 CDT