Re: find columns used in procedures

From: nullpointer <null_pointer_at_rediffmail.com>
Date: 20 Dec 2004 02:21:46 -0800
Message-ID: <1103538106.721695.285340@z14g2000cwz.googlegroups.com>

Actually the application uses tons of dynamic SQL. You are right I missed out the part about the dynamic SQL. The pseudocode that I was developing did contain recompiling all the procs before checking which were invalid so I had that covered. Any ideas on how to take care of the dynamic SQL. The situation does not look too bright.

I am thinking a complete overhaul is the only situation. Problem is that there is really tons of code. I just queried the user_source there are 25513 line of code :-((

regds
Dev Received on Mon Dec 20 2004 - 04:21:46 CST