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.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.