Oracle Forms Converter
- Typical workflow
- Getting started
- Operations in details
- Using a sample project
- Assessment report
- System requirements
- Frequently asked questions
This page describes the publishing process of the converted Oracle Forms.
The Publish operation builds a ReactJS web application from the converted Oracle Forms modules and then publishes generated SQL packages for each converted Oracle Forms module into the target database.
After publishing, you can use the Google Chrome browser to open the converted application using the link http://localhost:3000/.
Oracle Forms Converter supports two publishing modes: to Files and to Web Site.
Use the To Files mode to save the conversion output to files. This conversion output includes:
- SQL files. For each converted Oracle Forms module, the application generates one PL/SQL package with stored procedures and functions. If the original Oracle Forms module does not include these SQL statements, then Oracle Forms Converter does not generate the SQL file for this module.
Use the To Web Site mode to run converted forms in the web browser. Follow these steps to run your converted applications in the web browser.
After completing the forms conversion, click the Publish button.
Switch to the To Web Site tab.
- Select the Start form of your application from the drop-down list.
Check two following options: Create basic procedures and Fill Stored Procedures to create stored procedures for Web API and converted forms in your target database.
If you want to create stored procedures manually, you can do it with any SQL tool (Oracle SQL Developer, SQL Plus, Toad, etc.).
You should create stored procedures and types for Web API. The SQL file with procedures is in the Oracle Forms Converter installation directory. By default it is C:\Program Files\DBBest\OFConverter\Resources.
Create procedures for forms and other modules. You can find SQL files with procedures in the Result folder.
Uncheck the Create basic procedures and Fill stored procedures options. Then click the Publish button to publish a project without procedures.
After you click the Publish button, Oracle Forms Converter displays the Database Connection Warning message. Click Yes to specify the target database connection.
Scroll to the Target connection to Oracle DB section and specify Oracle Database connection credentials for your target database. Specifying connection credentials, please, make sure that the user has the following permissions:
- grant select on dba_synonyms to [schema_name]
- grant select on dba_objects to [schema_name]
- grant select any dictionary to [schema_name]
- grant select on dba_constraints to [schema_name]
- grant select on user$ to [schema_name]
- grant select on v_$transaction to [schema_name]
- grant select on v_$session to [schema_name]
- grant select on v_$mystat to [schema_name]
- grant unlimited tablespace to [schema_name]
- grant create session to [schema_name]
- grant create procedure to [schema_name]
- grant execute any procedure to [schema_name]
- grant create any type to [schema_name]
- grant execute any type to [schema_name]
Click the Save button. Your converted application will connect to this target database to read and write data. You may use the same database as a Source DB and Target DB. Your Oracle Forms and a new converted application can work with the same database simultaneously.
The publishing process can take a few minutes:
When Oracle Forms Converter completes the publishing process, the converted web application opens in a browser. The application is available at http://localhost:3000.
- To stop the web server and Web API created for the converted web application, use the Stop Server button.
- If something went wrong while publishing or converting, please contact [email protected].
Didn’t find the answer?
You can report problems, ask questions or share ideas for improvements on our email [email protected].