There were times when Quest Toad used to desert us with plain statements like “There was an error” especially while compiling procedures or funcations @ database level. We assume it was mostly because of the older versions of toad being used against latest versions of Oracle database. Well usually no firms want to upgrade to latest versions of Toad, as it involves the biting factor, money!
So, we started using Oracle’s own sql developer. The look and feel of Oracle’s SQL developer is so so, nothing compared to the neat and organized look of Quest toad, at the same time it is the most affordable tool for a developer, as it costs nothing for one to download and start using!
Not just that, if you have the latest version of Sql Developer, it does show you the exact error messages under almost all possible scenarios.
A quick post from a very satisfied Oracle’s SQL Developer suite!