Plug-in or tool for analyzing Table references?

[Stew Stryker]

Does anyone have a PSD plug-in or other utility that will generate a report of all Oracle objects that reference a specific database table, including the specific columns used by those objects? I know I can show the list of table References in the Object Browser, but that won't tell me which specific columns are used by each reference.

Rather than write my own all_source parser, I was hoping someone had already done something like this.

I realize this is a generic need, but I first looked at the plsqldoc tool in hopes it would do that, but it doesn't and my brain was still thinking in terms of a PSD tool. So here I am.

Thanks,

Stew

 

[Worker]

If you're on 11g, you may want to google PL/scope.

 

[Stew Stryker]

We're still at 10.1 for a few more months, but I'll look anyway.

Thanks,

Stew

 

[Stew Stryker]

Unfortunately, as far as I can tell, PL/Scope only seems to analyze objects within the code.

So I don't see how I can tell it, list all the procedures, packages and functions that use the "emp" table and show me exactly which table columns are being used by each along with whether they're updating or just reading the column.

That's really what I thought I was asking for.

Thanks anyway.