Re: SEQUENCE in a TRIGGER
From: Torsten Manz <Torsten.Manz_at_darmstadt.netsurf.de>
Date: 1996/02/25
Message-ID: <4gq3ut$mr4_at_gazette.omnilink.net>#1/1
Date: 1996/02/25
Message-ID: <4gq3ut$mr4_at_gazette.omnilink.net>#1/1
nathalie_at_MAIL.ATCON.COM (Nathalie) wrote:
> :NEW.P_KEY := next_key_gen.nextval;
Replace the line with
select [instance-name.]next_key_gen.nextval into :new.p_key from dual;
The instance-name may be not necessary.
Torsten.Manz_at_darmstadt.netsurf.de Received on Sun Feb 25 1996 - 00:00:00 CET