# Difference between Prompt / Commit / Rollback

**URL:** <https://forums.toadworld.com/t/difference-between-prompt-commit-rollback/40177>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [November 2, 2017, 6:21am UTC](https://forums.toadworld.com/t/difference-between-prompt-commit-rollback/40177 "2017-11-02T06:21:32Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Geo-x](https://avatars.discourse-cdn.com/v4/letter/g/ba9def/32.png) [@Geo-x](https://forums.toadworld.com/u/Geo-x)\
**Post date:** [November 2, 2017, 6:21am UTC](https://forums.toadworld.com/t/difference-between-prompt-commit-rollback/40177/1 "2017-11-02T06:21:32Z")

</div>

Hello everybody !

I make change on the configuration of my Oracle DB with Toad (Audit \> Noaudit) and when I leave Toad I've this message :

![toad_ok.jpeg](https://global.discourse-cdn.com/quest/original/2X/1/19d296214640a8db4f326e9ee0f7d93725166ce2.jpeg)

But I don't understand what is the difference between all this choices :

> PROMPT

> COMMIT

> ROLLBACK

Can you help me ?

Geo-x

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [November 2, 2017, 6:29am UTC](https://forums.toadworld.com/t/difference-between-prompt-commit-rollback/40177/2 "2017-11-02T06:29:28Z")

</div>

When your connection is ending, Toad will check to see if there is a transaction (data changed but not committed - but use of a DB Link will make cause Oracle to return TRUE for transaction if if there isn’t).

So when Oracle says yes, there is a transaction while you are ending your session in Toad, what do you want Toad to do? Automatically commit? Automatically rollback? Or ask you each time to commit or rollback(prompt)?

---

<div class="post-metadata">

**Author:** ![Geo-x](https://avatars.discourse-cdn.com/v4/letter/g/ba9def/32.png) [@Geo-x](https://forums.toadworld.com/u/Geo-x)\
**Post date:** [November 2, 2017, 6:37am UTC](https://forums.toadworld.com/t/difference-between-prompt-commit-rollback/40177/3 "2017-11-02T06:37:14Z")

</div>

Hello John and thank you for your answer.

I understand this window, it’s not a problem, but I don’t understand the difference between this choices : Prompt / Commit / Rollback
