others ways to write this trigger ?

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 Received on Wed May 29 2002 - 11:50:30 CDT