Bart Degryse wrote:
Dear all,
I'm having a problem with transactions and exceptions and need your advice.
I want a function to do two things:
- log something to a table (which is basically an insert)
- raise an exception under certain conditions
My problem is that when I raise the exception the insert is rolled back.
How can I work around that?
Either:
1. Not raising an exception, instead returning a status code to the
application.
2. Using dblink / dbi-link to reconnect to the database, which means
your logging will take place in its own transaction.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings