Autonomous transactions (sometimes) suck
Dev: Here’s the new package.
Me: Why are the procedures autonomous transactions.
Dev: Because they use the xxxx table.
Dev: That table is used by a lot of processes.
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.
I need some aspirin.
You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.