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

Geoff & Karsten:

That nailed it, thanks.

Geoff White <whiteg_at_ccis.adisys.com.au> wrote in message news:382239E8.642B8784_at_ccis.adisys.com.au...
> 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 Fri Nov 05 1999 - 11:14:48 CST