I need to read the oracle web form (forms running on Oracle 9iAs server, Oracle 10gAs server) values from a client application.
We wanted to know if we could use Oracle PJC to do that? The pjc code will run from the desktop and it should read the form values automatically.
Here is the summary of Use Case:
- code must be able to identify an
Oracle Form application (web deployment) and interacts with the form controls. The main functionalities that we are looking for are:
1. Identify that the application is starting up and display UI. This functionality is currently leveraging the Java Accessibility API which notifies a specific Secure Login hook when the UI is started.
2. Identify the addition/removal of graphical components in the application. Today the mechanism we have identified to achieve that is via a specific AWT container listener. When a component is added to the form we are notified of this addition. We then identify the specific parent window associated to that component. We have used that option as the specific accessibility
entry points meant for that purpose (topLevelWindowCreated) are not triggered for form applications).
3. Build the hierarchy of components for a given window. For this we are leveraging
Accessibility API (and AWT) to list all child elements of a given control.
4. Interact with the components: we use in that case the Accessibility API and AWT methods (for overcoming limitations of the Accessibility API where required)
We have looked at public Oracle documentation and identified the following:
- The Oracle.form.* packages javadoc don’t seem to be available publicly. We’d like to be able to access to this documentation so that we can see how to best leverage it for our integration.
- We have identified the PJC API as a possible integration point. In particular the IView interface. We think we maybe able to use that API for interacting with controls as in (4).
- We’d like to know if there are also mechanisms in PJC or Oracle.form packages that also could be used to address (2) where we would be notified specifically of Oracle form component addition, and (3) where we could given a given container list all of its components.
In Summary It would be greatly appreciated if you could provide:
- The
java doc for the Oracle Form packages.
- A recommendation to either use AWT approach vs. Oracle.Form/PJC APis approach.
- Eventually some sample code that shows how to use the Oracle Form or PJC APIs to address the needed functionalities.
Also, we’d like to know if it is possible to retrieve the current applet context(or a more direct method to identify the current application) using any PJC/Oracle Form API that you could point us to.
One reference(
http://sheikyerbouti.developpez.com/appletproperties/appletproperties.htm)
gives some information to query the applet parameters, however we don’t know how to get a handle on the current IHandler object from our code. We have access to the IView components added to a form, but there is no public accessor that can get to the IHandler object corresponding to an IView instance.