I came across this interesting piece of code while I was actually looking for searching for something else.
Create or replace procedure <>...
begin
merge into...
using...
-- more merge statements ..followed by all condition checks
EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;
WHEN OTHERS THEN
-- CONSIDER LOGGING THE ERROR AND THEN RE-RAISE
-- RAISE;
NULL;
END <>;
:)
1 comment:
Thanks for writing this.
Post a Comment