Posts:
383
Registered:
10/30/09
|
|
|
|
RE: Data Analysts results vs. Toad for Oracle 10.1 results
Posted:
Feb 23, 2010 10:02 AM
in response to: Eva
|
|
|
Sounds like either
|
|
|
|
|
|
|
RE: Data Analysts results vs. Toad for Oracle 10.1 results
Posted:
Feb 23, 2010 10:07 AM
in response to: Eva
|
|
|
Is HRVSTNUM defined as a DATE type in the database? If so, your problem may be
comparing a date with a character string relying on the default conversion. If
HRVSTNUM is a DATE, try it with o.HRVSTNUM =
TO_DATE('10/01/2009',’MM/DD/YYYY’) and n.HRVSTNUM =
TO_DATE('01/07/2010', 'MM/DD/YYYY') and see if that helps.
Nate Schroeder
IT Commercial Technical Services - Data Management Team
Monsanto Company
800 N. Lindbergh Blvd. G3WI - Saint Louis, MO - 63167
314-694-2592
|
|
|
|
|
|
|
RE: RE: Strange Behavior in Toad 9.7.2.5
Posted:
Feb 23, 2010 10:28 AM
in response to: Simoneau, Roger
|
|
|
Hey Roger,
>>> Please, don't even joke about this method of implementing a
> "sequence" -
>
> Heh, Norm has a point Rich. Some of the less experienced that follow
> this group won't realize you were being facetiously ironic 
Which was the thrust behind the verbiage of the Disclaimer... 
Rich -- [TeamT]
Disclaimer: The only clear choice is ambiguity.
|
|
|
|
|
|
|
Re: Data Analysts results vs. Toad for Oracle 10.1 results
Posted:
Feb 23, 2010 11:02 AM
in response to: SCHROEDER, NATH...
|
|
|
It is defined as text, not a date. It just looks like a date.
|
|
|
|
|
|
|
Re: Data Analysts results vs. Toad for Oracle 10.1 results
Posted:
Feb 23, 2010 11:04 AM
in response to: jdorlon
|
|
|
I am logged into the same schema, so #2 is out.
Would it be committed in TFO and not in DA? If so, how do I commit it
completely?
|
|
|
|
|
|
|
Re: Data Analysts results vs. Toad for Oracle 10.1 results
Posted:
Feb 23, 2010 11:11 AM
in response to: jdorlon
|
|
|
It was the committed issue. The data had been inserted and not committed.
Closing the session and reopening it showed none of the inserted rows had ever
been committed.
THANKS!!!!!
|
|
|
Posts:
107
Registered:
5/13/06
|
|
|
|
RE: Data Analysts results vs. Toad for Oracle 10.1 results
Posted:
Feb 23, 2010 11:22 AM
in response to: Eva
|
|
|
|
|
Just a note: we made a choice a while back to set the ?auto Commit? option
to OFF by default for Toad for Data Analysts. The thinking there is that Toad
for Data Analysts has a higher likelihood of being used by people who may not
understand the implications of a commit, unlike Toad for Oracle?s typical
users. As much as we?d like to assume that these folks have limited
permissions to the database, I think we all know that?s a scary assumption to
make! So in the interest of safety, the default option requires the user to
commit changes explicitly.
If you would prefer, you can change the default for Oracle connections by
checking the checkbox in the Options page (note: this applies to a new saved
connection in Toad for Data Analysts; existing saved connections need to be
modified individually). This way you won?t have to remember to commit your
changes.
--Daniel
|
|
|
|
|
|
|
Re: Data Analysts results vs. Toad for Oracle 10.1 results
Posted:
Feb 23, 2010 11:35 AM
in response to: dnorwood
|
|
|
|
|
Yeah, I saw that after the fact! Thanks for all the help and I promise to commit myself when appropriate from now on (pun fully intended)
________________________________
Yeah, I saw that after the fact! Thanks for all the help and I promise to commit
myself when appropriate from now on (pun fully intended)
|
|
|
Posts:
383
Registered:
10/30/09
|
|
|
|
RE: Data Analysts results vs. Toad for Oracle 10.1 results
Posted:
Feb 23, 2010 11:35 AM
in response to: Eva
|
|
|
Sorry, TFO. The commit should happen in the session where it was inserted.
|
|
|
Posts:
478
Registered:
8/10/06
|
|
|
|
RE: Data Analysts results vs. Toad for Oracle 10.1 results
Posted:
Feb 23, 2010 12:32 PM
in response to: jdorlon
|
|
|
AutoCommit should be outlawed if you ask me. I don?t even understand why you
would ever use it when working with Oracle?
|
Follow me on twitter @hillbillyToad
Check out my blog on ToadWorld
|
|
|
|
|
|
RE: Data Analysts results vs. Toad for Oracle 10.1 results
Posted:
Feb 23, 2010 2:35 PM
in response to: HillbillyToad
|
|
|
>> I don?t even understand why you would ever use [AutoCommit] when working
with Oracle?
Umm? masochistic tendencies?
Roger S.
|
|
|
Posts:
7
Registered:
12/1/09
|
|
|
|
RE: Strange Behavior in Toad 9.7.2.5
Posted:
Feb 24, 2010 8:40 AM
in response to: SCHROEDER, NATH...
|
|
|
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
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
