At the application level, we enforce "ALTER SESSION DISABLE COMMIT IN PROCEDURE" to restrict commits/rollbacks inside procedures, but this also blocks Pragma Autonomous Transactions as well.
Need a way (from the application side, no PL/SQL changes) to allow commits/rollbacks inside Pragma Autonomous Transactions while keeping other commits disabled.
Question:
How can we achieve this restriction at the application level without affecting autonomous transactions?