List, I am creating a trigger that should fire when records are
inserted into a table TEST and should send an email via utl_smtp.
The mailing is working fine. I am trying to get the trigger to fire after a group insert statement rather than each time a record is
inserted. I have not included the "for each row" syntax
but it still fires after each row is inserted. Will the entry below be regarded as one insert statement if
I put into a sql script and execute via sqlplus. insert into test values ('Suhen'); insert into test values ('Suhen'); insert into test values ('Suhen'); insert into test values ('Suhen'); My create trigger syntax used: create or replace trigger test_trigger
after insert on test begin send_mail
('Suhen','[EMAIL PROTECTED]','Insert','Records inserted into
test'); end; / I am busy looking through the docs for more info. Any help would be greatly appreciated. Regards Suhen |
- RE: create trigger after insert Suhen Pather
- RE: create trigger after insert Suhen Pather