Oracle Application Express Oracle Forms Conversion Project
Oracle Application Express, release 3.2 and above, enables you to load your Oracle Forms source into an Oracle Application Express project and generate an initial APEX application. The conversion automatically converts most user interface components but does not convert business logic implemented within triggers, program units, or PL/SQL libraries. Loading Oracle Forms definitions into the Oracle Application Express project provides analysis and tracking of the conversion project. Once the initial design has been generated, the rapid application development capabilities inherent within Oracle Application Express can be utilized to enhance and expand the generated application. Post-generation the business logic within Oracle Forms can be re-implemented and new screens which take advantage of Web 2.0 capabilities such as interactive reports and flash charts can be added using the wizards built into the Oracle Application Express builder.
|
Oracle Application Express
for Oracle Forms Developers
Feature
|
Oracle Forms
|
Application Express
|
Description
|
4GL
Declarative
|
Yes
|
Yes
|
Oracle
Forms renders applications using metadata stored in an .fmx file. Application
Express renders applications using metadata stored in an Oracle database.
|
4GL
Languages
|
SQL
and PL/SQL
|
SQL
and PL/SQL
|
Oracle
Forms runs client-side PL/SQL. Application Express uses server-side PL/SQL.
|
User
Interface
|
Java
|
HTML
|
Oracle
Forms is accessed using a web browser and its user interface is rendered
using a JVM. Application Express is also invoked from a Web browser but its
user interface is HTML and JavaScript.
|
Page
Layout
|
Windows
/ Canvases
|
Page
/ Regions
|
Oracle
Forms uses exact positioning and Application Express uses HTML-relative
positioning.
|
Client-side
Field Control
|
Form
triggers
|
Javascript
and AJAX
|
Oracle
Forms provides robust field-level validation and event processing.
Application Express supports declarative page-level validation and event
processing. Programmatic field-level validation and event processing requires
Javascript and AJAX.
|
Web
Service Support
|
Yes
|
Yes
|
Both
Oracle Forms and Application Express support the calling of Web Services, for
example BPEL.
|
Charting
|
BI
Beans
|
Flash
Charts
|
Oracle
Forms uses BI Beans as its integrated charting engine. Application Express
uses Flash Charts as its integrated charting engine.
|
Locking
|
Pessimistic,
Optimistic, Custom
|
Optimistic,
Custom
|
Oracle
Forms supports a range of locking models with pessimistic as the default. Due
to its asynchronous architecture, Application Express uses an optimistic
locking model.
|
Database
Connections
|
Synchronous
|
Asynchronous
|
Oracle
Forms uses synchronous connections to allow transactions to span multiple
screen interactions. Application Express does not transparently allow
transactions to span page views. Application Express programmatically
supports transactions spanning page views using collections.
|
Concurrent
User Support
|
Database
connectivity maintained by user session
|
Database
connectivity only maintained for the processing of requests
|
Each
connected user in Oracle Forms maintains a synchronous connection to the
Oracle database. Application Express users are asynchronously connected to
the Oracle database.
|
Architecture
|
3
Tier
|
2
Tier
|
With
Oracle Forms, Application logic is processed in the Oracle database, a
mid-tier Forms Server, or in the rich client. With Application Express,
PL/SQL application logic is processed within the Oracle database. Client-side
logic is implemented using JavaScript. HTTP communications are facilitated
using Apache and Mod/PLSQL.
|
Oracle Application Express Application Migration Workshop (Application Migrations) enables you to
migrate a Microsoft Access application or convert an Oracle Forms application to an
Oracle Application Express application.
|
No comments:
Post a Comment