# How can I turn on AUTOCOMMIT? **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [February 9, 2010, 1:03pm UTC](https://forums.toadworld.com/t/how-can-i-turn-on-autocommit/9220 "2010-02-09T13:03:33Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [February 9, 2010, 1:03pm UTC](https://forums.toadworld.com/t/how-can-i-turn-on-autocommit/9220/1 "2010-02-09T13:03:33Z")
In the status bar TOAD tells me “AUTOCOMMIT OFF”. How can I turn it on? ## Ben View this message in context: [http://old.nabble.com/How-can-I-turn-on-AUTOCOMMIT--tp27520353p27520353.html](http://old.nabble.com/How-can-I-turn-on-AUTOCOMMIT--tp27520353p27520353.html) Sent from the TOAD mailing list archive at [Nabble.com](http://Nabble.com). ---
**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:** [February 9, 2010, 1:11pm UTC](https://forums.toadworld.com/t/how-can-i-turn-on-autocommit/9220/2 "2010-02-09T13:11:24Z")
Options -\> Oracle -\> Transactions -\> Commit after every statement. ---
**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\ **Post date:** [February 9, 2010, 1:22pm UTC](https://forums.toadworld.com/t/how-can-i-turn-on-autocommit/9220/3 "2010-02-09T13:22:03Z")
It’s in the options under the View menu. ---
**Author:** ![christopher.tryonhat](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/christopher.tryonhat/32/139_2.png) [@christopher.tryonhat](https://forums.toadworld.com/u/christopher.tryonhat)\ **Post date:** [February 9, 2010, 1:22pm UTC](https://forums.toadworld.com/t/how-can-i-turn-on-autocommit/9220/4 "2010-02-09T13:22:27Z")
Ben, Autocommit is an sql plus command. IT is generally used during script execution. You can do the following Set autocommit on Or set autocommit off In your script. Check the options window (type commit in the search box in the lower left). Toad has a few commit options as well. chris ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [February 9, 2010, 1:27pm UTC](https://forums.toadworld.com/t/how-can-i-turn-on-autocommit/9220/5 "2010-02-09T13:27:15Z")
Hey Ben, > In the status bar TOAD tells me "AUTOCOMMIT OFF". > > How can I turn it on? The goal of my email isn't to tell you how to turn it on, but to emboss it into your memory so that when this option comes back to bite you, you'll remember me. Just years of paranoia and having twice been put through a once-in-a-lifetime ringer of bad lack of forethought. Now, about your question: You don't mention the version of Toad you're using, but View-\>Toad Options-\>Oracle-\>Transactions-\>"Commit after every statement" (or search for "commit" in the options) toggle should do what you're looking for. Best of luck! Rich -- [TeamT] Disclaimer: The best tool a shop teacher has is his remaining 9 fingers. ---
**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\ **Post date:** [February 9, 2010, 1:28pm UTC](https://forums.toadworld.com/t/how-can-i-turn-on-autocommit/9220/6 "2010-02-09T13:28:16Z")
Or in other words, just because you can, doesn’t mean you should. ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [February 9, 2010, 2:19pm UTC](https://forums.toadworld.com/t/how-can-i-turn-on-autocommit/9220/7 "2010-02-09T14:19:34Z")
What Jeff and Rich are saying, I think, is that committing after every statement is usually a VERY BAD idea. Commits should be done based on the real transactions you’re working with. They should be done when it logically makes sense, not after every statement. Consider a real world example of an ATM. First SQL statement: withdraw $100 from my account (something like "insert into financial\_trans (account, transaction\_amount) values (myAccountNumber,-100); Second SQL statement: deliver $100 to the user at the ATM If you autocommit after the first and then the second one fails, the money leaves your account and you get nothing. If you commit after the second succeeds, then the money gets transferred right. And if there’s a failure at the ATM or in the network, you simply roll back the transaction. Database work typically involves a bunch of individual statements grouped into logical transactions. Committing after every statement is almost always bad design. And, as Rich said, it will eventually bite you. I’ve been bitten too. So I recommend leaving autocommit turned off. – jim ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [February 9, 2010, 2:36pm UTC](https://forums.toadworld.com/t/how-can-i-turn-on-autocommit/9220/8 "2010-02-09T14:36:11Z")
> I've been bitten too. So I recommend leaving autocommit turned off. > > -- jim I should start a new group on Facebook called "Transactionally Paranoid Cheeseheads". ;D Rich -- [TeamTPC] Disclaimer: I must have missed the Toad for Oracle Superbowl commercial ---
**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\ **Post date:** [February 10, 2010, 3:56am UTC](https://forums.toadworld.com/t/how-can-i-turn-on-autocommit/9220/9 "2010-02-10T03:56:58Z")
Morning all, late to the party as usual! I blame time zones! > > What Jeff and Rich are saying, I think, is that committing > > after every statement is usually a VERY BAD idea. > > Oh yes indeedy, a very very bad thing. If you do this, you _will_ > > [eventually] end up with a trashed database. In fact, as an enhancement request, I'd suggest that the option be dropped completely in future versions of Toad to avoid the distress that comes with a commit half way through a script that means when it goes wrong, the rollback is only partial - in other words, back to an unknown point in the transaction rather than undoing the whole transaction. I wonder how many people out there in Toad Land actually turn autocommit on? The example I much prefer is a similar one to the banking analogy given earlier: You wish to transfer $100 from your savings account to your cheque account: UPDATE SAVINGS ACCOUNT SET TOTAL = TOTAL - 100; [AUTO COMMIT] UPDATE CHEQUE ACCOUNT SET TOTAL = TOTAL + 100; [AUTO COMMIT] As was pointed out earlier, if it works, fine. If it fails after updating the savings account, it loses you $100 and the bank gains $100 as it has no idea where it came from - finders keepers. Now you might think that the bank would do this instead: UPDATE CHEQUE ACCOUNT SET TOTAL = TOTAL + 100; [AUTO COMMIT] UPDATE SAVINGS ACCOUNT SET TOTAL = TOTAL - 100; [AUTO COMMIT] I wonder if you can think of a reason why they wouldn't! 😉 Without autocommit it's fine and dandy whichever way around it works: UPDATE CHEQUE ACCOUNT SET TOTAL = TOTAL + 100; UPDATE SAVINGS ACCOUNT SET TOTAL = TOTAL - 100; COMMIT; Now, if it fails at any point in the transaction, your money is safe and so is the bank's. Remember, a transaction is a logically complete update that must succeed or fail as a single unit. Autocommit - just say NO! Cheers, Norm. [TeamT] Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at [www.environment-agency.gov.uk](http://www.environment-agency.gov.uk) Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at [www.environment-agency.gov.uk](http://www.environment-agency.gov.uk) ---
**Author:** ![PetervanRijn](https://avatars.discourse-cdn.com/v4/letter/p/ce73a5/32.png) [@PetervanRijn](https://forums.toadworld.com/u/PetervanRijn)\ **Post date:** [February 10, 2010, 4:11am UTC](https://forums.toadworld.com/t/how-can-i-turn-on-autocommit/9220/10 "2010-02-10T04:11:54Z")
There is one form of 'autocommit' that is very hard to turn off. We regularly receive sql-scripts to run that contain a mix of DML- and DDL-statements. But still the single commit on the last line! 🙂 Peter Op 10-02-2010 10:56, Dunbar, Norman schreef: > Morning all, > > late to the party as usual! I blame time zones! > > > > What Jeff and Rich are saying, I think, is that committing > > > after every statement is usually a VERY BAD idea. > > > Oh yes indeedy, a very very bad thing. If you do this, you _will_ > > > [eventually] end up with a trashed database. > > In fact, as an enhancement request, I'd suggest that the option be > dropped completely in future versions of Toad to avoid the distress that > comes with a commit half way through a script that means when it goes > wrong, the rollback is only partial - in other words, back to an unknown > point in the transaction rather than undoing the whole transaction. > > I wonder how many people out there in Toad Land actually turn autocommit > on? > > The example I much prefer is a similar one to the banking analogy given > earlier: > > You wish to transfer $100 from your savings account to your cheque > account: > > UPDATE SAVINGS ACCOUNT > SET TOTAL = TOTAL - 100; > [AUTO COMMIT] > > UPDATE CHEQUE ACCOUNT > SET TOTAL = TOTAL + 100; > [AUTO COMMIT] > > As was pointed out earlier, if it works, fine. If it fails after > updating the savings account, it loses you $100 and the bank gains $100 > as it has no idea where it came from - finders keepers. Now you might > think that the bank would do this instead: > > UPDATE CHEQUE ACCOUNT > SET TOTAL = TOTAL + 100; > [AUTO COMMIT] > > UPDATE SAVINGS ACCOUNT > SET TOTAL = TOTAL - 100; > [AUTO COMMIT] > > I wonder if you can think of a reason why they wouldn't! 😉 > > Without autocommit it's fine and dandy whichever way around it works: > > UPDATE CHEQUE ACCOUNT > SET TOTAL = TOTAL + 100; > > UPDATE SAVINGS ACCOUNT > SET TOTAL = TOTAL - 100; > > COMMIT; > > Now, if it fails at any point in the transaction, your money is safe and > so is the bank's. > > Remember, a transaction is a logically complete update that must succeed > or fail as a single unit. > > Autocommit - just say NO! > > Cheers, > Norm. [TeamT] > > Information in this message may be confidential and may be legally > privileged. If you have received this message by mistake, please notify > the sender immediately, delete it and do not copy it to anyone else. We > have checked this email and its attachments for viruses. But you should > still check any attachment before opening it. We may have to make this > message and any reply to it public if asked to under the Freedom of > Information Act, Data Protection Act or for litigation. Email messages > and attachments sent to or from any Environment Agency address may also > be accessed by someone other than the sender or recipient, for business > purposes. If we have sent you information and you wish to use it please > read our terms and conditions which you can get by calling us on 08708 > 506 506. Find out more about the Environment Agency at > [www.environment-agency.gov.uk](http://www.environment-agency.gov.uk) > > Information in this message may be confidential and may be legally > privileged. If you have received this message by mistake, please notify > the sender immediately, delete it and do not copy it to anyone else. > > We have checked this email and its attachments for viruses. But you > should still check any attachment before opening it. > We may have to make this message and any reply to it public if asked to > under the Freedom of Information Act, Data Protection Act or for > litigation. Email messages and attachments sent to or from any > Environment Agency address may also be accessed by someone other than > the sender or recipient, for business purposes. > > If we have sent you information and you wish to use it please read our > terms and conditions which you can get by calling us on 08708 506 506. > Find out more about the Environment Agency at [www.environment-agency.gov.uk](http://www.environment-agency.gov.uk) ---
**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\ **Post date:** [February 10, 2010, 4:22am UTC](https://forums.toadworld.com/t/how-can-i-turn-on-autocommit/9220/11 "2010-02-10T04:22:28Z")
Morning Peter, > > There is one form of 'autocommit' that is very hard to turn off. > > > > We regularly receive sql-scripts to run that contain a mix > > of DML- and DDL-statements. > > Yes, we used to get those from vendors as well. However, I created a set > > of scripting standards, had it approved and all our vendors now have a > > copy - and get any updates as and when required - and they have been > > told that any scripts that they supply which do not adhere to the > > scripting standards will be rejected when a DBA QAs the script(s) before > > application. Once a couple of scripts have been rejected and thrown back for correction, they soon wise up. > > But still the single commit on the last line! 🙂 > > Glad it's not just us then! The use of a commit on the final line of a > > DDL script shows a severe lack of understanding about exactly how Oracle > > works - in fact, mixing DML and DDL shows this too. Our standards demand > > that vendors do not put a COMMIT or ROLLBACK into any script. They do put a prompt at the end telling the DBA that they should commit if no errors occurred otherwise, rollback. After all, how does the script writer know that our database has, for example, got enough UNDO to cope with what turns out to be a huge transaction generating lots and lots of UNDO and which blows away all of the UNDO - then commits. As we stipulate, the DBA applying the script(s) is the only one who dictates whether a commit or rollback is required and appropriate. Which means, also, that the script better have a spool at the start and spool off at the end - of it fails QA as well! Cheers, Norm. [TeamT] Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at [www.environment-agency.gov.uk](http://www.environment-agency.gov.uk) Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at [www.environment-agency.gov.uk](http://www.environment-agency.gov.uk) ---
**Author:** ![PetervanRijn](https://avatars.discourse-cdn.com/v4/letter/p/ce73a5/32.png) [@PetervanRijn](https://forums.toadworld.com/u/PetervanRijn)\ **Post date:** [February 10, 2010, 4:31am UTC](https://forums.toadworld.com/t/how-can-i-turn-on-autocommit/9220/12 "2010-02-10T04:31:29Z")
Op 10-02-2010 11:22, Dunbar, Norman schreef: > dictates whether a commit or rollback is required and appropriate. Which > means, also, that the script better have a spool at the > start and spool off at the end - of it fails QA as well! > > Cheers, > Norm. [TeamT] We're drifting a bit too off-topic I'm afraid, but talking about spooling, I don't know if your standards mention spooling as well. In the past we used an application and received vendor supplied scripts every once in a while. They always spooled to "C:\temp". very nice when running the scripts on a unix-box. Well, enough ranting for today. cheerio Peter ---
**Author:** ![wimdelange\_062](https://avatars.discourse-cdn.com/v4/letter/w/9fc348/32.png) [@wimdelange\_062](https://forums.toadworld.com/u/wimdelange_062)\ **Post date:** [February 10, 2010, 5:48am UTC](https://forums.toadworld.com/t/how-can-i-turn-on-autocommit/9220/13 "2010-02-10T05:48:11Z")
---
**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\ **Post date:** [February 10, 2010, 6:54am UTC](https://forums.toadworld.com/t/how-can-i-turn-on-autocommit/9220/14 "2010-02-10T06:54:07Z")
Oracle provides a command for this CREATE SCHEMA. Basically you can wrap a collection of DDL commands and treat them as one transaction (all or one). It’s been in Oracle since at least Oracle 8.i. ---
**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\ **Post date:** [February 10, 2010, 7:06am UTC](https://forums.toadworld.com/t/how-can-i-turn-on-autocommit/9220/15 "2010-02-10T07:06:15Z")
Here’s the command description from the 8i docs: CREATE SCHEMA Purpose Use the CREATE SCHEMA to create multiple tables and views and perform multiple grants in a single transaction. To execute a CREATE SCHEMA statement, Oracle executes each included statement. If all statements execute successfully, Oracle commits the transaction. If any statement results in an error, Oracle rolls back all the statements. ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [February 10, 2010, 7:34am UTC](https://forums.toadworld.com/t/how-can-i-turn-on-autocommit/9220/16 "2010-02-10T07:34:20Z")
I have a stored procedure that runs the following dynamic sql. When the sql is run in the procedure it returns 0 rows. When the exact same sql string is run in a standard editor window it returns 366 rows. I can see that the fetch is working and the sql is being built to be correct. The value of v\_SQL is exactly what is expected, which is why I can run it in a standard editor window. It just returns 0 rows inside the procedure. Any ideas? All of this is run on Toad 10.1 in debug mode. This is just the beginning of the loop. The end loop exists later but there is much more in the routine than this and this is the part that is failing again and again. OPEN Edits\_Tab; Loop Fetch Edits\_Tab into v\_FieldName, v\_Condition, v\_Result, v\_DataEditName; Exit when Edits\_Tab%NOTFOUND; v\_SQL := ‘(select count(\*) ‘; v\_SQL := v\_SQL||‘from ‘||UPPER(p\_TableName)||’ t ‘; v\_SQL := v\_SQL||‘where t.ERRFLAG=’‘0’’’; if p\_DataVrsn ‘ALL’ then v\_SQL := v\_SQL||‘and t.DATAVRSN = ‘’’||p\_DataVrsn||’’’ ‘; end if; v\_SQL := v\_SQL||’ and (’||UPPER(v\_Condition)||’)) '; ``` execute immediate v_SQL into v_RowCount; ``` Thank you!!! Eva ---
**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\ **Post date:** [February 10, 2010, 7:44am UTC](https://forums.toadworld.com/t/how-can-i-turn-on-autocommit/9220/17 "2010-02-10T07:44:43Z")
When you run code in PL/SQL you cannot inherit privs granted to roles within that code – the grants must be made directly. It’s possible that when you run as script it works because roles grants function as expected and it does not when done as PL/SQL because you loose the roles grants …. Not 100% sure this is your issue – but a common thing to check …. ---
**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\ **Post date:** [February 10, 2010, 7:48am UTC](https://forums.toadworld.com/t/how-can-i-turn-on-autocommit/9220/18 "2010-02-10T07:48:34Z")
Did you compile with debug? If so, you should be able to see the value of v\_SQL inside the loop as it iterates by just putting your mouse over the text. I’m wondering if your EXIT WHEN is getting fired prematurely…as you step through the loop does it make it through the entire construct? You could also see this if you ran the Profiler – it records each line of code executed. ---
**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\ **Post date:** [February 10, 2010, 9:06am UTC](https://forums.toadworld.com/t/how-can-i-turn-on-autocommit/9220/19 "2010-02-10T09:06:53Z")
Hi Wim, > > Hmmm. Sounds very nice. Never give this a thought. Sounds > > good. Are those standards for the scripts available for the public? [http://qdosmsq.dunbar-it.co.uk/blog/?p=236](http://qdosmsq.dunbar-it.co.uk/blog/?p=236) Cheers, Norm. [TeamT] Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at [www.environment-agency.gov.uk](http://www.environment-agency.gov.uk) Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at [www.environment-agency.gov.uk](http://www.environment-agency.gov.uk) ---
**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\ **Post date:** [February 10, 2010, 9:08am UTC](https://forums.toadworld.com/t/how-can-i-turn-on-autocommit/9220/20 "2010-02-10T09:08:03Z")
Peter, > > We're drifting a bit too off-topic I'm afraid, but talking about > > spooling, I don't know if your standards mention spooling as well. Yes, if the script is "myFirstScript.sql" then the spool must be to "myFirstScript.log" (or .txt or something else). Common spool files are not permitted. Cheers, Norm. [TeamT] Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at [www.environment-agency.gov.uk](http://www.environment-agency.gov.uk) Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at [www.environment-agency.gov.uk](http://www.environment-agency.gov.uk) [Next page](https://forums.toadworld.com/t/how-can-i-turn-on-autocommit/9220.md?page=2)