Basic PL/SQL - Oracle SQL Jumpstart with Examples - page 538

Figure 24.3
Executing a
Named, Stored
Procedure from
within SQL.
EXCEPTION WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE(SQLERRM(SQLCODE));
RAISE;
END;
/
CREATE OR REPLACE TRIGGER uARTIST
AFTER UPDATE OF NAME ON ARTIST FOR EACH ROW
BEGIN
DBMS_OUTPUT.PUT_LINE('Artist changed from '
||:OLD.NAME||' to '||:NEW.NAME);
EXCEPTION WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE(SQLERRM(SQLCODE));
RAISE;
END;
/
CREATE OR REPLACE TRIGGER dARTIST
AFTER DELETE ON ARTIST FOR EACH ROW
BEGIN
DBMS_OUTPUT.PUT_LINE('Artist '||:OLD.NAME
||' has been deleted');
EXCEPTION WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE(SQLERRM(SQLCODE));
RAISE;
END;