I don’t even understand why you would ever use [AutoCommit] when working
with Oracle…
Umm… masochistic tendencies?
Roger S.
Group,
Sorry for all the confusion. Let me clear up this whole mess.
Last Friday (late in our work day), my coworker called me to her desk and showed
me the problem. She insisted that it had not existed before in the code (which
she had written 2 years ago) and it was now showing up in the code. She showed
me part of the 10000+ insert script from before and the “new” script
she had just run which had the code. On quick check it looked like the offending
code was added to the entire script.
I was getting ready to leave (within an hour) when she did this and she strongly
asked me to post the message to the group to find out why. I did not have time
at that point to investigate further. She was gone both Monday and Tuesday so I
could not investigate it more until now.
This morning, I got with her and had her show me what she had done. She showed
me where the code was added (she had saved the script). I went out to our source
control and looked at the original. Guess what? It was the same as her
supposedly affected code. The “begin dbms_lock.sleep(1); end” code
was in her original script from 2 years ago but only in the portion (about 5000
lines into the code) that she had shown me Friday as being representative of the
entire script. Apparently, she had added it to slow the transactions down on our
old server 2 years ago and forgotten about it.
So, to make a long story short, there is no problem with Toad and Toad did not
insert the code. It was just a panic attack from my coworker and lack of time
for me to totally validate her claims.
Sorry again for the confusion and thanks for your help.
Lynn