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
__._,_.___
Posted by: martin_gbg_@hotmail.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
.
__,_._,___
No comments:
Post a Comment