Here’s a list of issues in TOAD v11 to v12.
1. PL/SQL Condition Defines, breaks navigator.
Embedded conditional defines in statements break TOAD’s navigator, making it totally useless, see screenshot below. Function InsertOrUpdateChildXML has a conditional define to ensure Oracle does not use deprecated method ExistsNode on 11gR2. AddNodeIfNotExists and Test2 (and all other subsequent procs) do not appear in navigator. Having a broken navigator makes developing large packages extremely difficult.
2. Syntax Highlighter - Missing functionality
a) No syntax highlighting for PL/SQL Condition Defines.
An option to highlight conditional defines should exist in Options | Editor | Behaviour | Languages (PL/SQL) | Syntax Highlighting. I probably could add one myself with a regular expression, but it should be part of the editor defaults.
**b) No option to change DBMS_Output “Marked Block”. **
I changed my default background to blue to avoid eye glare (Options | Editor | Display | Background Color). But can now no longer see selections in DBMS_Output window (if I want to select a block and copy to clipboard), and there seems to be no option to change it.
3. Master-Detail Browser
a) No option to product SQL for Master-Detail Browser record(s).
The Master-Detail Browser is very useful, but its use is diminished by lacking a facility to generate SQL for a selected record in one of the grids. e.g. I add a Parent -> Child -> Grandchild relationship. If I go to one of the grids, it would be nice to be able to generate the SQL for the record in question in that grid. For example, in the grandchild region, have buttons for generating SQL for record and generate SQL for grid. E.g. For record in grandchild grid…
from GRANCHILD gc
join CHILD c on c.ID = gc.PARENT_ID
join PARENT p on p.ID = c.PARENT_ID
where gc.ID = 123
b) No option to clear everything to create a new set of relationships.
There should be a button “Create New Master-Detail relationship”
4. Default Background Colour not honoured in many sub forms.
I set my background colour to blue, but lots of places still show source code on a white background and due to font colours scheme, I can no longer see the code. What’s the point of having default colours / fonts if it’s ignored?
a) Substitution variables prompt dialog => run query with variables.
b) Options | Editor | Behaviour | Languages | General => preview colour highlighting