# Commit Question

**URL:** <https://forums.toadworld.com/t/commit-question/10829>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [October 28, 2011, 10:11am UTC](https://forums.toadworld.com/t/commit-question/10829 "2011-10-28T10:11:03Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![leo.drobnisdealertra](https://avatars.discourse-cdn.com/v4/letter/l/e495f1/32.png) [@leo.drobnisdealertra](https://forums.toadworld.com/u/leo.drobnisdealertra)\
**Post date:** [October 28, 2011, 10:11am UTC](https://forums.toadworld.com/t/commit-question/10829/1 "2011-10-28T10:11:03Z")

</div>

A co-worker of mine puzzled me a bit.

He installed TOAD 11.0.0.116. When he runs a commit (typed in the editor) and  
uses either F5 or execute as script, the commit does not actually commit into  
the DB, even thought the committed message shows up in TOAD. When F9 or execute  
statement is clicked, commit works fine.

According to him, TOAD 10.6.0.42 worked just fine. The actual commit button  
works as well.

Below is the spooled SQL.

I am very curious as to what is going on.

F5 COMMIT:

---

<div class="post-metadata">

**Author:** ![GTDG](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gtdg/32/140_2.png) [@GTDG](https://forums.toadworld.com/u/GTDG)\
**Post date:** [October 28, 2011, 10:13am UTC](https://forums.toadworld.com/t/commit-question/10829/2 "2011-10-28T10:13:48Z")

</div>

Are you running F5 in the main Toad session or in its own session (Options -\>  
Oracle -\> Transactions -\> Execute scripts in Toad session)? If that’s not  
checked, you’re performing a commit in a different session than the main Toad  
session.

Greg

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [October 28, 2011, 10:13am UTC](https://forums.toadworld.com/t/commit-question/10829/3 "2011-10-28T10:13:58Z")

</div>

I’ll bet it’s a session issue. He probably has “run scripts in  
separate session” or whatever that option is called set, so F5 and Run As  
Script do the commit in a different session, and so don’t commit the work  
from the session in which he did the work.

Nate Schroeder

Enterprise Services - Data Management Team

Monsanto Company

800 N. Lindbergh Blvd. LC4D - Saint Louis, MO - 63167

314-694-2592

---

<div class="post-metadata">

**Author:** ![leo.drobnisdealertra](https://avatars.discourse-cdn.com/v4/letter/l/e495f1/32.png) [@leo.drobnisdealertra](https://forums.toadworld.com/u/leo.drobnisdealertra)\
**Post date:** [October 28, 2011, 10:26am UTC](https://forums.toadworld.com/t/commit-question/10829/4 "2011-10-28T10:26:38Z")

</div>

Yes, it is checked.

---

<div class="post-metadata">

**Author:** ![leo.drobnisdealertra](https://avatars.discourse-cdn.com/v4/letter/l/e495f1/32.png) [@leo.drobnisdealertra](https://forums.toadworld.com/u/leo.drobnisdealertra)\
**Post date:** [October 28, 2011, 10:27am UTC](https://forums.toadworld.com/t/commit-question/10829/5 "2011-10-28T10:27:47Z")

</div>

Just replied to Gregory.

It is not the case.
