Re: help with database

you are selecting ALL customer_ids into :new.customer_id...

not complete syntax
create sequence newcustseq.....

create or replace trigger wine_cust_trigger before insert on wines
for each ro
begin
select newcustseq.nextval into :new.customer_id from dual; end ;
/

OR

this very poor-man's sequence that is not very scalable due to locking etc..
create or replace trigger wine_cust_trigger before insert on wines
for each ro
begin
select max(customer_id)+1 into :new.customer_id from customer ; end ;
/
Received on Tue Apr 18 2006 - 14:58:47 CDT