Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Using Sequence Gen in Trigger

Using Sequence Gen in Trigger

From: Rick Ryan <rickryan_at_global2000.net>
Date: 1997/04/28
Message-ID: <5k2cl3$u64@news.global2000.net>#1/1

Can a Sequence be used in a insert before row Trigger?

create or replace trigger package_id_trigger

        before insert on tracking
        for each row 

begin
           
        :new.R_45_145_Package_ID := package_seq.nextval;
       

end;

When I compile this trigger I get a error stating that a Sequence can't be used in this context. It seems you can only use " package_seq.nextval" in an insert statement?

Any input.........

                      Thanks Rick Ryan....  
                      rickryan_at_global2000.net
Received on Mon Apr 28 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US