Overblog Tous les blogs Top blogs Technologie & Science Tous les blogs Technologie & Science
Editer l'article Suivre ce blog Administration + Créer mon blog
MENU

Articles Oracle Forms, PL/SQL, Java, J2EE

Publicité

Forms : a JavaBean to encapsulate JDAPI functions

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.
Publicité
Retour à l'accueil
Partager cet article
Repost0
Pour être informé des derniers articles, inscrivez vous :
Commenter cet article
W
I great idea!I have a wrote a lot of JDAPI programs. The Jdapi is powerful.I have the same question like Tulio, will the Java Bean able to change a form at runtime? That were new to me and very interesting.nice dayWolfgang Brandy
Répondre
F
The JDAPI is useful to update .FMB files, so really nothing at runtime. As I said,  the aim of this tool is to modify .FMB source files with the content of an XML input file, to those people that do not know how to implement the JDAPI stuff.
T
Sorry but I dont understand.Are You speacking about a runtime modification or a design time one?TksTullio
Répondre
F
This JavaBean would allow to modify .FMB files in mass. The main aim is to apply modifications on Windows, Canvases, Item, etc. on a group of several source files.
P
Maybe under the same title of Object Lib:1. Be able to change the canvas or stackes back ground colorsin 6i (c/s) my canvas was normal GREY. This was the default but when i converted to 10g the background  black and white. So did the buttons. So a way to change attributes on canvas/stacks?
Répondre
P
Another interesting tool to manipulate FMBs is the Forms API Master by http://www.orcl-toolbox.com/ I like it, because the language of the script engine is very PL/SQL-Pascal like. And I event do not talk about the FMB compare, power search, ... which the tool also offers.Patrick
Répondre
F
Patrick,The tool you point is probably powerful,but also very expensive, that does not correspond with my idea of  "free" solutions given on my blogs ;D