trigger failure

From: Paul Kreis <nkrepa_at_ascom.ch>
Date: 1998/04/01
Message-ID: <3521FFE8.3DA4_at_ascom.ch>#1/1


[Quoted] 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;

the sequence:

    create sequence seq_test increment by 1

       start with 10
       maxvalue 99
       minvalue 10
       cache 20
       order


I work with oracle server 7.3.3.3 (sqlplus) on solaris 2.5.1.

regards

-- 
=================================================================
Paul C. Kreis                           Informatiker Ascom 
					Phone: ++41(0)31 999 6605 
paul.kreis_at_ascom.ch                     Natel: ++41(0)79 432 0514
Received on Wed Apr 01 1998 - 00:00:00 CEST

Original text of this message