Exception handling is followed after an sql command, using ‘Exception’ i.e.:

[sql]begin
DELETE FROM TABLE1 t1 WHERE t1.table_id = variable1;
EXCEPTION
WHEN OTHERS THEN
INSERT INTO ERR_DELETE
(table_id, description)
VALUES
(t1.table_id, variable1);
end;[/sql]