Skip to Main Content

Java and JavaScript in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Subject : Allow Commit/Rollback in PRAGMA AUTONOMOUS_TRANSACTION

Yo HAnApr 3 2025

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?

Comments
Post Details
Added on Apr 3 2025
0 comments
164 views