trigger failure
From: Paul Kreis <nkrepa_at_ascom.ch>
Date: 1998/04/01
Message-ID: <3521FFE8.3DA4_at_ascom.ch>#1/1
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 0514Received on Wed Apr 01 1998 - 00:00:00 CEST