Re: primary keys

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/06/11
Message-ID: <339f0415.4685205@www.sigov.si>#1/1

On Wed, 11 Jun 1997 14:10:22 +0200, "Pawe³" <pp_at_inwar.com.pl> wrote:

> ....[SNIP].....
>
>CREATE OR REPLACE TRIGGER triggername
>BEFORE INSERT
>ON tablename
>FOR EACH ROW
>DECLARE
>BEGIN
> :new.id:=seq1.nextval;
> ....
>END;
>

Just a small correction - the above trigger won't compile because you can't simply assign a new value from a sequence to a varible. You have to isue a SELECT INTO to get next value from a sequence, so instead

   :new.id := seq1.nextval;
you have to execute

   SELECT seq1.nextval INTO :new.id FROM dual;

Regards,

---

Jurij Modic                             Republic of Slovenia
tel: +386 61 178 55 14                  Ministry of Finance
fax: +386 61  21 45 84                  Zupanciceva 3

e-mail: jurij.modic_at_mf.sigov.mail.si Ljubljana 1000

---

Received on Wed Jun 11 1997 - 00:00:00 CDT