Autonomous transactions (sometimes) suck

Conversation:

Dev: Here’s the new package.
Me: Why are the procedures autonomous transactions.
Dev: Because they use the xxxx table.
Me: ???
Dev: That table is used by a lot of processes.
Me: ???
Dev: if I don’t use autonomous transactions, I get a mutating trigger error.
Me: An autonomous transaction does not “fix” the problem.
Dev: That’s the way we’ve been fixing it.
Me: !! :-(

I need some aspirin.

LewisC

You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

2 Comments »