Trigger syntax

From: David Vodnansky <vodnansky_at_icl.cz>
Date: 1997/01/30
Message-ID: <32F074C3.15F3@icl.cz>#1/1

Hi all,

I have problems with trigger syntax in Oracle (I usually use Interbase). Simple example :

create table adresy (id number(3,0),text varchar2(25)); create sequence gen_adresaid ......;

CREATE TRIGGER gen_adr_id
BEFORE INSERT ON ADRESY
FOR EACH ROW
BEGIN
  new.id:=gen_adresaid.nextval; <--- this line is wrong, why ? end;

Thanks for advice.

---

David Vodnansky
ICL Czech republic
vodnansky_at_icl.cz

---

Received on Thu Jan 30 1997 - 00:00:00 CST