level 1
累的尴尬
楼主
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;
2020年08月11日 05点08分
1
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;