Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Help me with Triggers Please!!
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;
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