My Oracle Support Banner

How to Disable Automatic Commit in APEX_SQL Command (Doc ID 2737537.1)

Last updated on JANUARY 08, 2021

Applies to:

Oracle Application Express (APEX) - Version 18.2.0.00.12 and later
Information in this document applies to any platform.

Goal

After logging in to INTERNAL from APEX as an admin user, Manage Instance>Feature Configuration>SQL Workshop>

Enable Transactional SQL Commands=yes

A checkbox for auto-commit appears, as shown in the screen below.

 

The above check box is checked by default, is there way to prevent this from being checked by default?

 Also how to disable automatic commit in APEX_SQL command?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.