Re: trigger failure

The select statement syntax should be:

    select seq_test.nextval into :new.switchnr from dual ;

In general, you can find compilation errors by:

SHOW ERROR Good luck,

Paul.

Paul Kreis <nkrepa_at_ascom.ch> wrote in article <3521FFE8.3DA4_at_ascom.ch>...
> what is false in this trigger. SQLPlus fehler: Warning: Trigger created
> with compilation errors.
>
> the trigger:
>
> create or replace trigger tr_test
> before insert on switch
> referencing old as old new as new
> for each row
> begin
> :new.switchnr := select seq_test.nextval from dual;
> end;
Received on Wed Apr 01 1998 - 00:00:00 CEST