I am trying to create a AFTER INSERT Trigger. I created it and it worked for one record. But when I am trying to input multiple inserts it gives me error even on my insert statement. I am sure the syntax is right. Can anyone confirm this syntax. When I created a small table for testing this syntax worked... I dont know why its not working here.
INSERT INTO media (
media_name,
description,
active_flag,
activity_log,
data_entry_status_code,
category_id,
vendor_id,
created_by,
created_date
)
VALUES
('Test Media20', 'Test Description20', 1, 'Test Log20', 1, -1, -1, -1, '1/1/2001 12:00:00 AM'),
('Test Media21', 'Test Description21', 1, 'Test Log21', 1, -1, -1, -1, '1/1/2001 12:00:00 AM'),
('Test Media22', 'Test Description22', 1, 'Test Log22', 1, -1, -1, -1, '1/1/2001 12:00:00 AM')