Problem with triggers

I am running Oracle 7.3.2.2 on Netware 4.1 and am having problems creating triggers. Here is the table and the trigger definition I am trying to use:

create table trigger_test_table
(

   id number(16,0) not null,
   name varchar2(128)
);

create sequence test_trigger_id

   start with 1
   increment by 1
   maxvalue 999999999999999;

create or replace trigger ttt_insert_trigger before insert on trigger_test_table for each row declare

   new_id number;
begin

   select test_trigger_id.nextval into new_id from dual;    :new.id := new_id;
end ttt_insert_trigger;

The table and the sequence create just fine, but I can not create the trigger. The only error message that SQL*Plus(3.3) gives me is an error compiling the trigger. I type: "show errors" and it says: "no errors".

This seems pretty straightforward to me. Does anyone see what might be wrong? Does anyone have any better way of creating triggers since SQL*Plus does not give the needed help?

Thanks for your time.

K. Wade Turner
turnerk_at_dimensional.com Received on Wed Aug 13 1997 - 00:00:00 CDT