Re: others ways to write this trigger ?

"Fred Burlaud" <fburlaud_at_com6.fr> wrote in message news:3CF506D6.58AA0AF_at_com6.fr...
> Hello,
> I need to parse this trigger code with an API function
> that doesn't support the : caracter
>
> -- My trigger uses a sequence to increment a field (AutoNum):
>
> create or replace trigger trig_galapia
> before insert on galapia
> for each row
> begin
> if :new.<primary_key_field> is null then
> select seq_x.nextval into :new.<primary_key_field> from dual;
> end if;
> end;
>
> could you help me to rewrite this trigger without :
> Is it possible ?
>
> thanks
> Fred
>

NO

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address