Re: find columns used in procedures

On 2004-12-17, Mark D Powell <Mark.Powell_at_eds.com> wrote:
> Why go to all that trouble when you can just query
> dba_dependencies to find the list of views, packages, functions, stored
> procedures, and synonyms dependend on a table?
>

 Mark, thanks for your comment - I agree that on table level it is useless. (and really crazy - so I stated it right in my previous post:-))

But I can use that "invalidation" technique to help finding column dependencies in procedures.

I just checked - dba_dependencies will show you table, referenced by program, but not column. If I create table, procedure and than start dropping *columns*, than invalidation of procedures will show me in which programs that dropped column was used.

As for me, it is another alternative of going through code manually. (However, still big task, and this approach will work for relatively small number of tables/columns and big number of plsql code - that is the case with datawarehouse, I assume)

What do you think about this statement of mine - still crazy or getting better? :0-) Received on Sat Dec 18 2004 - 18:16:48 CST