Hi,
I have a procedure that recalculates financial instrument (10 000+). This
operation takes 4-6 hours and an occasional exception can occur in one of these
instruments (eg E_MISSING_CURRENCYRATE)
-I do not want that exception to prevent the rest of the instruments to be
recalculated (primary).
-I would like the error written ta a log if possible (secondary)
I tried
WHEN ANY DO
IN AUTONOMOUS TRANSACTION DO
INSERT INTO LN_PLAN_ERRORS (LOAN_ID, ERRORDATE, MSG)
VALUES (:ID, CURRENT_TIMESTAMP.....
but it isnt behaving as you might expect (though in line with documentation)
since it stops execution en rolls back the transaction even if I am not
rethrowing the exception.
Can I get what I want?
/Martin
