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