Oracle Forms

Oracle Application Express Forms Converter

1. Oracle Application Express Forms Converter Author: Packt Publishing

   Oracle Application Express Forms Converter By Douwe Pieter van den Bos This book tries to cover the subject of transforming Oracle Forms in APEX. It s a relatively simple subject but the book tries to expand the information and provide additional techniques on how to implement this process. The name Douwe Pieter van den Bos may not be really popular

2. Preparing your Oracle Forms Conversion Author: Packt Publishing

   Before we start our actual Forms Conversion project we have to take some steps. We have seen in the previous chapter that we need to understand some things about the application. Now it s time to gather the sources of our application and get our hands dirty. When we are participating in a Forms Conversion project it means we take the source files

3. Oracle Forms - Creating XML files Author: Packt Publishing

   Creating XML files To create XML files we need three parts of the Oracle Developer Suite. All of these parts come with a normal 10g or 9i installation of the Developer Suite. These three parts are the Forms Builder the Reports Builder and the Forms2XML conversion tool. The Forms2XML conversion tool is the most extensive to understand and is

4. Oracle Forms Modules Author: Packt Publishing

   To convert the .FMB .OLB and .MMB files to XML we need to do the following steps in the command prompt Forms Modules The following steps are done in order to convert the .FMB file to XML 1. We will change the working directory to the directory that has the FMB file.  In my example I have stored all the files in a directory called summit

5. Oracle Forms - Report Files Author: Packt Publishing

   In our example we will convert the Customers Report from a RDF file to an XML file. To do this we follow the steps given here 1. We need to open the Employees.rdf file with Reports Builder. 2. Open Reports Builder from your Start menu. If Reports Builder is opened we need to cancel the wizard that asks us if we want to create a new report. 3.

6. Oracle Forms - PL/SQL Libraries Author: Packt Publishing

   To convert PL SQL Libraries to an XML format it s easiest to use the convert command that comes with the Report Builder. With this command called rwconverter we define the source type call the source and define the destination type and the destination. In this way we have control over the way we need to convert the original .pll file to a .pld

7. Oracle Forms - Understanding XML Author: Packt Publishing

   If we take a look inside the XML files we just created we will notice a few things. I use SQL Developer of Oracle to look inside the XML files we just created. It s a free tool that we will need for several other tasks during our Conversion project and it does the job. But of course you can use a different XML editor to examine the XML files. When

8. Oracle Forms - The target database Author: Packt Publishing

   In order to convert your Forms applications to APEX we also need the database model on our target area. Using Oracle s SQL Developer we will be able to do both an export and an import on the database of the database objects we need in our application. In Chapter 1 we talked about the objects we needed in the application we are converting. The import

9. Oracle Forms - Summary Author: Packt Publishing

   Summary In this chapter we learned everything we need to do to get ready for our Forms to APEX conversion project. Here are the necessary steps we went through before we started We have seen what files we need. These are the.FMB Forms Modules .OLB Object Libraries .MMB Menu Modules .PLL PL SQL Libraries and RDF REX or JSP Reports