CREATE OR REPLACE TRIGGER TRG_TEST5 AFTER INSERT or UPDATE ON test5 REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW DECLARE BEGIN IF tiaojian THEN DBMS_ALERT.SIGNAL('SIG_TEST5', MSGMSGMSG); END IF; NULL; EXCEPTION /* Unexptected Error */ WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE( 'Unexpected error is occured in trigger. SQLCODE:' || TO_CHAR(SQLCODE) ); DBMS_OUTPUT.PUT_LINE( SQLERRM ); END;