How to modernize a Forms application with Oracle Cloud Services by Ludovic Dessemon


Forms is not dead. 15 years ago I heard that Oracle Forms has no future.15 years later, Oracle Forms 12c is here.
If your strategy is to keep Forms in place for protecting your investments and you are convinced that Forms will continue to support your business, this article could be of interest for you.
Do you have a digital transformation strategy while maintaining Oracle Forms at the heart of your information systems?
For answering the question "How to modernize an Oracle Forms application for my business ?" we do have a lot of approaches and solutions.
In this article I would like to share a "concept" for integrating Oracle Cloud Services within an Oracle Forms application. 
Oracle Cloud Services, however different by functionality and scope, share a common feature: accessibility via REST APIs.
I would like to show how to integrate Oracle Document Cloud Service (DOCS) within my Oracle Forms application. For doing this, I use the REST APIs provided by DOCS.
Forms is a GUI solution using SQL and PL/SQL. When we want to consume some REST APIs from Forms, we often use a PL/SQL approach. The last Oracle Database 12c gained a lot of improvements for exposing and consuming services via REST APIs. In the context of REST APIs we can use an alternative approach for Oracle Forms : Java, for example, or Javascript. I’m using Java for many years but recently I discovered that Javascript is pretty cool to use:
– It’s easy to learn.
– Libraries! Javascript has libraries for everything. Literally. You can build a complete mobile website in a day using JQuery mobile.
– Speed: Javascript is fast. A Javascript client side reduces load on the server.
– Ajax: Every web developer knows and loves Ajax.
For developing with Javascript I chose Oracle JET. JET stands for Javascript Extension Toolkit.
Oracle JET is targeted at intermediate to advanced JavaScript developers working on client-side applications. It’s a collection of open source JavaScript libraries along with a set of Oracle contributed JavaScript libraries that make it as simple and efficient as possible to build applications that consume and interact with Oracle products and services, especially Oracle Cloud services.
I’m using Oracle JET for embedding Oracle Forms and for extending Oracle Forms with the power of Javascript.

Oracle JET makes use of some popular Open Source libraries.

Oracle JET uses RequireJS. RequireJS is a JavaScript file and module loader that makes it easier to manage library references and is designed to improve the speed and quality of your code.
I have created the module "oracleforms" for managing the integration of Oracle Forms inside Oracle JET. Read the complete article here.

WebLogic Partner Community

For regular information become a member in the WebLogic Partner Community please visit: ( OPN account required). If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn Forum Wiki


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.