Oct222010
ravicreate table t1(a number); create table t2(b number); create or replace trigger ins_trg before insert on t1 for each row when(:new.a<=5) begin insert into t2 values(:new.a); end ins_trg; i have created t1,t2 tables.i like to create a trigger on t1 table by when clause as shown in above.when i am creting trigger it is showing this"ORA-25000 invalid use of bind variable in trigger WHEN clause" what is the solution for this.