TOAD has warts

djberg96 on 2004-05-21T14:59:54

I, like Dilbert, have an irrational desire to have the latest version of any software I own. So, at work a while back I upgraded from TOAD 6.x to TOAD 7.4 on my WinXP Pro box. Mistake!

This thing is really a piece of poo. If I have a long running query and try to do *anything* else within TOAD, it hangs and crashes. Also, the SQL parser leaves a lot to be desired and some DDL statements I've written just seem to silently fail for no apparent reason, yet they work fine in sqlplus. It also screws up placeholders sometimes.

Oh, sure, I could select the option to thread the queries to try to avoid some of the problems, but I'm too paranoid about the "runaway query" and a call from an angry DBA. Besides, I shouldn't have to do that.

However, I like the schema browser way too much to give it up, and that's pretty much all I'm using it for at the moment. I shoulda stuck with 6.x.


Irrational Beatings

chaoticset on 2004-05-21T16:33:41

I, like Dilbert, have an irrational desire to have the latest version of any software I own.
I may have once possessed that, but Microsoft beat it out of me. I'm pretty much happy with any version of software that does something I need.

Re:Irrational Beatings

rjbs on 2004-05-21T17:49:46

Yeah. There's very little software that I'll update "just because." Vim, for example, get patched daily, and rather than keep up, I just compile from CVS now and then. Anything from OmniGroup gets fairly blindly updated. Any kind of server or GNU utility or Win32 program, though? Not unless it prevents me from getting pwned or sued, basically.

Same thing works for hardware. My workstation at work (running WinXP) is a dual P3 Xeon 933. My boss is occasionally amazed when I pass up offers for a new dual 2GHz or whatever the new model is. I mean... I'm running Vim and perl!

7.5 ?

tinman on 2004-05-22T11:55:50

Admittedly, I've not done much with Oracle (or TOAD) for nearly 6 months, but before I left, the old corporate was rolling out 7.5, which seemed to be the best yet of all the 7.x series thus far.

If you do more PL/SQL development than database administration (which was the case for me), you might also like to try out AllroundAutomation's PL/SQL developer (I begged and begged and finally got a license for it ;)

I happen to be the counter example, obsessive checks for updates on most software I use regularly :) Of course, it doesn't hurt to keep an older version lying around either.

Re:7.5 ?

djberg96 on 2004-05-24T18:45:44

Hmm...either I'm blocked or the link is dead. Oh, and it turns out I have 7.5.2, not 7.4.

Re:7.5 ?

tinman on 2004-05-30T12:31:31

link worked for me.. perhaps this link might work ? The earlier url redirects here.

Hmm, I just visited Toadsoft and notice that they're upto 7.6 :) That's in line with their "new version every 6 months or so" policy. Some friends swear by SQL navigator too, although I think it's a bit overkill :)