Mostly used Allround Automations PL/SQL Developer besides self-made or collected scripts executed in sqlplus.
One of the function I fail to find (so far) in Toad 22.214.171.124 (Trial) is how to view the cause of a compilation error. I.e. when trying to compile a view where one of the used tables missing or grants missing etc I get this info from Toad: “15:44:04 Info: 1 view had errors on compile. Last error message: Success with compilation error”
at best I can read “ORA-00942:…” but no hint which of the two tables that are joined to build the view that are the cause of the failing compilation.
This could of course be solved with scripts or even easier with PL/SQL Developer… but how do I find the solution in Toad ??
IN PL/SQL Developer I will the exact line in code wher the compile fail… anything similair in Toad ??
In trial to 7 November than we have to make a decision what tool to invest into.