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