Re: Enhance Used By with PL/Scope?
Richard Squires <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <20216586.1331241324358704437.JavaMail.SYSTEM@alvqcfw02> |
Message from: R Squires OK, I've had a bit of a play with it and it's not perfect. I don't think its easily queried and would likely result in too big a performance hit on the Used By results (due mainly to the recursive structure of the data). I'd be happy to be proved wrong though. :) I'd be just as happy with being able to view the results from ALL_SOURCE where the line(s) of code was LIKE my referenced package. An option to fetch extended results in the Uses/Used By tab perhaps? It's a popular idea at least: http://toadfororacle.ideascale.com/a/dtd/Used-By-tab-being-more-informative/313080-8477 _______________________________________ Historical Messages Author: Richard Squires Date: Mon Dec 19 21:24:34 PST 2011 OK, I've had a bit of a play with it and it's not perfect. I don't think its easily queried and would likely result in too big a performance hit on the Used By results (due mainly to the recursive structure of the data). I'd be happy to be proved wrong though. :) I'd be just as happy with being able to view the results from ALL_SOURCE where the line(s) of code was LIKE my referenced package. An option to fetch extended results in the Uses/Used By tab perhaps? It's a popular idea at least: http://toadfororacle.ideascale.com/a/dtd/Used-By-tab-being-more-informative/313080-8477 __ Author: Richard Squires Date: Mon Dec 19 17:27:32 PST 2011 Have you looked at whether PL/Scope information could be used within TOAD? I'd be particularly interested in whether the Used By data could be enhanced to include additional PL/Scope information (if available). What I'd really like to see on the Used By tab of TOAD is how a package is used by another package (not just that it is). For example, is the reference to a procedure/function call or a package variable perhaps. Would PL/Scope provide us with that detail and could it be easily (and efficiently) added to the Used By result set? As you can see, I've not had a chance to play with it myself so I'm wondering if anyone else has looked at PL/Scope and how we might be able to start enhancing TOAD to take advantage of this additional information. Richard __ _______________________________________