cancel
Showing results for 
Search instead for 
Did you mean: 

When commit is executed, it commits all the other users DMLs as well not only the specific login user in Oracle DB.

GouthamMane
Level 2
HI All,
I am facing some issue on below.

When commit is executed, it commits all the other users DMLs as well not only the specific login user in Oracle DB.

Pl help me on the same.

------------------------------
Goutham Mane Tech Lead
Lead Technical Trainer
TechMahindra
Europe/London
------------------------------
2 REPLIES 2

ritansh.jatwani
Level 9
Hi @Goutham Mane,

Can you please provide more insights on the issue. How are you performing the commit statement?​

------------------------------
Ritansh Jatwani Senior Consultant
Consultant
EY
Gurgaon
*If you find this post helpful mark it as best answer
------------------------------

EVIPUTI
MVP
If you want to commit a single statement use should use an autonomous transaction . Example :

CREATE OR REPLACE PROCEDURE p_insert
AS
PRAGMA AUTONOMOUS_TRANSACTION;

BEGIN -- Main transaction suspends here.

INSERT INTO your_table VALUES (1); -- Autonomous transaction begins here.
COMMIT; -- Autonomous transaction ends here.

END; -- Main transaction resumes here.


------------------------------
------------------------------
Vipul Tiwari
Senior Process Simplification and Optimization Designer(Solutions Architect)
Fidelity International
------------------------------
------------------------------
------------------------------ Vipul Tiwari Senior Process Simplification Developer Amazon ------------------------------