Sunday, March 30, 2008

consider..but never code

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:

Anonymous said...

Thanks for writing this.