Retrieve Code Analysis metrics history from DB
Brian R Trull <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <OF64762E37.F5884B86-ON85257A17.005EDB1A-85257A17.0060E194@mck.us.ray.com> |
I've been playing with the feature to save Code Analysis results to the DB. I chose the option to have the related tables created in the local user, as opposed to the public Toad user. I ran a couple of analyses to test it. I see their entries in the tables, and I can run reports, but when I click the "Retrieve Code Analysis metrics history from DB" icon (little eyeglasses over a disk drive), I get "No history available." I activated the SQL Tracker to see what is going on and was able to see why it didn't work. Two queries are generated, one each for the package and package body of whatever package I have selected. The problem is that it generates this clause, "AND cx."SCHEMA" = 'N/A'", instead of the actual user name, which is what was saved in the schema column.