And while we're at it, how do I switch between autocommit and non-autocommit?
+5
A:
There is no such thing as autocommit in Oracle (server). Some client applications however default to autocommit (meaning they deliberately issue a commit between each statement). You will have to read the documentation of your application in order to determine if this is the case.
Vincent Malgrat
2009-09-02 10:26:12
Thanks. Found it:sql*plus: SQL> show autocommit; autocommit OFF SQL> set autocommit ON;sqlpython does not seem to have this feature.
0x89
2009-09-02 12:39:44
@0x89: SQL*Plus is only a CLIENT application, it is NOT the Oracle DB :)
Vincent Malgrat
2009-09-02 13:45:12
Yes, I got that after reading your answer. So I added the information how to set sql*plus to autocommit, so that people who basically just want to know how to switch sql*plus to autocommit can read it here.
0x89
2009-09-03 21:35:23