multiple insert - handling exceptions
551628Apr 17 2007 — edited Apr 17 2007Hi
I am doing a multiple insert from one schema to another.
INSERT INTO aa.a
SELECT *
FROM bb.a
WHERE ....
INSERT INTO aa.b
SELECT *
FROM bb.b
WHERE ....
I want to handling exception in each insert and needs to rollback the all the previous transactions if any of the insert fails.
Please tell me how to raise the exception in each insert to handle it ?