if you can (and I assume you can) change the trigger code and if you are on 8i, make use of autonomous transactions. so you can capture all required information and insert it into a table.
You may want to write this as a separate procedure and call that with appropriate information from the trigger, so that the procedure is the one that has the autonomous pragma. Or put messages on a db pipe, have a pipe daemon listen continuously and as soon as it gets message, dump into another table and commit. HTH Raj ______________________________________________________ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art!
*********************************************************************2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *********************************************************************2