Re: INSERT trigger doesn't work...why not?

I think what you need is:

create or replace trigger cc.person_insert_trigger  before insert
 on cc.person
 for each row
 when (new.person_id is null)
 begin
  select cc.person_s.nextval
  into :new.person_id
  from dual;
end;

HTH
Geoff

John Haskins wrote:

> Greetings:
> <snip>

>
Received on Thu Nov 04 1999 - 19:59:04 CST