Skip to Main Content

APEX

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!

Apex 23.1: Autocommit off in SQL Workshop -> SQL Commands

SmithJohn45Aug 20 2024 — edited Aug 21 2024

i followed below steps to have Autocommit checkbox in SQL Workshop → SQL Commands so i can turn off Autocommit to avoid any loss.

Login as Administrator ( Internal Workspace ) -my local VM-

Go to Manage Instance → Feature Configuration → SQL Workshop → Set Enable Transactional SQL Commands to Yes then Apply Changes

now login as developer/normal user
goto SQL Workshop => SQL Commands
you should see a checkbox with label Autocommit, check/uncheck it and test.

i UnCheck the checkbox before label Autocommit and tested DML as in screenshot below, it didn't worked. how i can do this?

regards

Comments
Post Details
Added on Aug 20 2024
0 comments
265 views