Inserting into (table with trigger)

r123456 · #1 (**permalink**) 10-15-03, 11:55

Hey,

I need to insert data into a table that has a trigger constarint on it, there are 100 + rows of which the trigger raises an exception on < 10 of them. The problem is that no row is being inserted.

insert into t.value1, t.value2
select a.value2, a.value2
from temp a

trigger is on table t.

dbmadcap · #2 (**permalink**) 10-22-03, 15:57

You could write a pl/sql cursor to loop thru each row and insert into the table. Something like this:

Code:

begin
  for c_rec in (select value2 from temp) loop
    begin
      insert into t(value1, value2)
        values(c_rec.value2, c_rec.value2);
    exception
      when others then
        dbms_output.put_line('error:');
    end;
  end loop;
end;
/

Internet Services

Web Development

Digital Marketing

Consumer Tech