Nested Transactions

Is is possible to nest transactions with Oracle? I have a web app calling packaged procedures via MTS (Microsoft Transaction Server) To implement this, all commits and rollbacks are handled by MTS. The catch here is that I want to write and commit errors to a error table as they occur. Is it possible to wrap the error handling within a separate transaction so I can commit it without committing all the other work in progress? If this is not doable, what are my options other then logging to a file?

Thanks in advance!

Andrew Adams Received on Sat Sep 18 1999 - 14:28:40 CDT