Trigger for inserting data

Trigger for inserting data

I have worked this code for inserting values into a table but this is not
inserting. Trigger is created on table tab1 .
CREATE OR REPLACE TRIGGER trg_ai_insert_tab1
AFTER INSERT
ON MMSTLOGINDATA
BEGIN
INSERT INTO mapusrbbranch (ENTRYNO,
BU,
REPCODE,
BANKBRCODE,
LOCCODE,
USERTYPE)
SELECT SEQ_MAPUSRBBRANCH.NEXTVAL,
BU,
REPCODE,
BRCODE,
LOC_CODE,
USERTYPECODE
FROM tab1;
EXCEPTION
WHEN OTHERS
THEN
logerrors ('trg_ai_insert_tab1',
'TRIGGER INSERTION ERROR',
SQLCODE,
SQLERRM,
'E');
END;
/
I have tried this code as well .
CREATE OR REPLACE TRIGGER trg_ai_insert_tab1
AFTER INSERT
ON tab1
FOR EACH ROW
BEGIN
INSERT INTO mapusrbbranch (ENTRYNO,
BU,
REPCODE,
BANKBRCODE,
LOCCODE,
USERTYPE)
VALUES (SEQ_MAPUSRBBRANCH.NEXTVAL,
:new.BU,
:new.REPCODE,
:new.BRCODE,
:new.LOC_CODE,
:new.USERTYPECODE);
-- FROM tab1;
EXCEPTION
WHEN OTHERS
THEN
logerrors ('trg_ai_insert_tab1',
'TRIGGER INSERTION ERROR',
SQLCODE,
SQLERRM,
'E');
END;
/