[OFF-TOPIC] Tool similar to SQLImpact

[MarcusRangel]

Dear friends,

Does anybody know a tool for finding out the impact on Oracle Forms when you change a database object ? For example, if I am changing EMP.ID from number(5) to number(10), which forms do I have to check ?

TIA

 

[D.]

Hi,

"Oracle Designer" will do this for you. You can reverse engineer your application & database into the repository, and then run impact assessment reports against the repository.

What version of Forms are you running ?

Alternative (home built) solution :-
You could also convert the Form to text format (*.fmt) and grep through it. That's how we did it. Every form (and everything else) was automatically "exported as text" when checked in to PVCS and held in a directory. A UNIX utility was then used to do an impact assessment against all code (SQL, UNIX, PACKAGES, FORMS, REPORTS, Pro*C). This was just a simple GREP on all relevant parts of the code - eg. Pro*C only had the EXEC SQL sections checked for the input string etc.

Hope this helps....

Cheers,
D.