Trigger Dependencies / References view all out of whack ... is it me?
SM_WorkApr 11 2013 — edited Apr 17 2013When I click on a trigger in the tree ... say an ISO trigger on a view that will clearly insert or update or delete from select underlying table ...
Under "References" tab ... I see nothing.
Under "Dependencies" tab ... I see mulitples of tons of things ... that to me ... have no relation atall_ to that trigger ... e.g. a table from a completely different group of tables.
But also ... a LOT of those wrong / odd relations ... like someone forgot a "select distinct" somewhere.
And wading thru this long list is ... VERY hard ... all I expected was ...
the view, maybe its synonym, its master table(s) to which it was going to write, and a few standard functions / package calls that we use in all our ISO triggers (and those items in turn do not reference the odd relations that are showing up instead).
Is this a bug perchance?
My SQL Dev version is ... 3.2.20.09 (downloaded 1/29/13).
Please advise. Thanks for your time.
(is there a way to post an image?)