I have a trigger on a table that calls an external dll to pass a message (string) to MQSeries. A question has arisen regarding transactional consistency. My trigger code has logic to trap and handle any errors returned by the dll.
I'm worried that records are being rolled back out of the table if any of the dll calls fail. Does the code provided appear to handle any errors and prevent the record from being rolled back? If I haven't provided enough information let me know.