A collegue of mine had to debug all his code, twice, to try to find why one of his tables wasn’t populated.
Here is why: He asked to execute a script (script didn’t contained a commit statement) in sql*plus at someone of the production team. That guy opened sql*plus, executed the script and closed window (File>Exit) through the menu.

Now if you close sql*plus by using the menu or the X icon on the top right of your window, sql*plus DOES NOT commit when quiting. When you type at the prompt: “exit” or “quit” then you commit and exit sql*plus.

Just keep that in mind and btw the option “autocommit” has noting to to with this problem (on a lot of blogs and forums they thing autocommit will autocommit on exit, NOT!)

This entry was posted on Tuesday, July 29th, 2008 @ 11:10 am on the category Scripts, Sql*Plus. You can follow any responses to this entry through the RSS 2.0 You can leave a response, or trackback from your own site.