Help me with Triggers Please!!

From: Ricky <rforde_at_sangacorp.com>
Date: 1997/07/18
Message-ID: <33CF7F57.AFB8F22B@sangacorp.com>#1/1

I created this trigger to perform an insert on another table: CREATE OR REPLACE trigger ricky
  before insert on studentdb
DECLARE
  dumstudent char(3);
begin

   insert into studentdb values(studentdb.stuid);    SELECT studentdb.stuid

      INTO dumstudent
      FROM studentdb;

    insert into temptable values(dumstudent); end;

But this error keeps occurring when I do the insert on studentdb: insert into studentdb values('555')

            *
ERROR at line 1:

ORA-00984: column not allowed here
ORA-06512: at line 4
ORA-04088: error during execution of trigger 'SYSTEM.RICKY'

By the way I'm using Personal Oracle 7. Received on Fri Jul 18 1997 - 00:00:00 CDT