It seems that many people would like to apply massive changes within their existing Forms applications, but do not have the skill (or the time) to deal with the
Oracle JDAPI stuff.
I have started a project targeting to do this kind of massive changes from a JavaBean, so a simple Forms module, fed by an XML input file.
Actually, the project is able to do the following transformations:
Triggers:
- Add pl/sql code to existing trigger (before or after existing code). Create the trigger if it does not exist.
- Remove an existing trigger
- Change the execution hierarchy of an existing trigger
- Replace some PL/SQL code by another one
- Delete some PL/SQL code
Program units:
- Add a program unit
- Replace some PL/SQL code by another one
- Delete some PL/SQL code
PL/SQL Libraries:
- Rename all attached libraries to lowercase or uppercase
- Attach a library
- Detach a library
Object libraries:
- Subclass a component from an Object library
Miscellaneous:
- Compile the module after changes
I need your participation, and wait for your comments to add more valuable features.
If you already have this kind of problem to solve, feel free to send me your comments and give details about what you would be expecting from this project.