Forms Community Meeting and questions to Michael Ferrante

Next week at the German Oracle User Group (DOAG) conference, we have a Forms community meeting Tuesday night at 6 pm in the Galileo Lounge.

As a preparation, we would like to ask you to send us questions, so that we get them answered by Michael Ferrante.

We are all looking forward to a great conference. Forms is coming again!

Please send the questions to

See you in Nuremberg

Oracle Forms and Firefox 52

This morning was the last day for Oracle Forms in Firefox, I thought...

At 9:00 AM I had no problems starting my Forms-Runtime. Firefox 51.0 was the actual version at that point.

After lunch and restarting my Firefox I was running 52.0 with the new feature "no JAVA please" :-)

Very bad is, that firefox didn't give you any hint, when starting a Forms-URL. The only thing you see is an empty screen.


The Future of Forms – DOAG Forms Day in Berlin, 18.01.2017

Today, and it's the last day of the old year, I had to announce, that the German Oracle User Group (DOAG) will have a whole day of forms-talks:

DOAG Forms-Day 2017

Come and share your Forms 12c experience with the community.

I wish all of you a good start in the new year

What’s new in Forms 12c, part 2

Let's now look into the Form Builder and what changes we got there.

First we see the facelift in the Open-Dialog. It's now the typical Windows-Dialog, where you have much more flexibility.

New features in the Convert-Dialog:

  • New Feature "Converting to and from XML"
  • Checkbox "Overwrite"
  • Checkbox "Keep window open", if you have to convert many files at once.

Preferences-Dialog, Tab "General":

  • The checkbox "Hide PL/SQL Compile Dialog" is new
  • Web Browser location (Forms 11g: (more...)

What’s new in Forms 12c?

Here are some of the differences which I found in the new Forms 12c version. And some things, that didn't change.

Let's start with the Object Navigator. Left side is Forms 11g, right is Forms 12c.

There are absolutely no changes between the two versions.

Same picture when we look at the menu and toolbar. No changes.

And now we see the big difference between 11g and 12c. The last decades Forms was known as (more...)

Forms 12c installation

My first installation two days ago wasn't stable. So I had to read the certification matrix to see, what's the problem.

Windows 10 was a little bit to new for my first installation.

So I tried today Windows 8 in a virtual machine. And that's it.

The difference to my first installation is, that the Forms Configuration Manager didn't start.

In Windows 8 the Configuration Manager did start without problems. These steps were shown in (more...)

Forms 12c launched this night

Some hours ago Oracle launched the new release of Oracle Forms. And here are my first steps installing the new Forms 12c. The OS, in which I tried the installation was a VMware with Windows 10 on my iMac. 1)
After the installation My first start of the new Forms
More about it in the next days Have fun with Forms 12c Gerd

Easy logging and debugging, version 2.0

Each application needs a simple way to log errors and find them. The following technique can also be used to debug Forms, Reports and PL/SQL. This version 2.0 has an important change. The username ist stored in the debugging-data and the viewname has changed a little bit.

First create the table, sequence and view to store the logging-information:
INSERT_USER VARCHAR2(30) (more...)

Just found

now I need a floppy drive for 3,5"


Rumors about Oracle Reports 12c

For nearly six weeks, it is rumored that Oracle Reports will not appear in the version 12c.

Since then, I tried to get information on this topic. After a few emails I got the info I needed.

The rumors are definitely wrong and no one at Oracle wants to cancel Reports 12c.

I hope that this cools down the rumor mill a little bit.


The German ADF-Community-Book was released today

The German ADF- (and Forms-) Community released their first book.

The "ADF book" is a compilation of German lectures, articles and workshop tutorials in Oracle ADF (some of the contributions are in English!). The authors are members of the German ADF community. The time frame covers the years 2010 to 2014. The project "ADF book" was implemented by a team of staff from partner companies and Oracle.

40 authors wrote 70 contributions on 1400 (more...)

Don’t use INC and DEC in PL/SQL Libraries

In my oldest PL/SQL-Library in Forms 4 my first procedures were:

P_Number := P_Number + 1;

P_Number := P_Number - 1;

In some variations with one or two parameters I used this Increment and Decrement since 20 years! Without having trouble in all the days.

Now I found out, that DEC isn't working in newer Oracle Forms (more...)

New Statement of Direction, September 2013

The actual lifetimes of Forms and Reports can be found in this document.

The most important at a glance:

Here are some of my older Statement of Directions private copies:

SoD Oracle Fusion 2013 / 09
SoD Forms 2012 / 03
SoD Oracle Fusion 2010 / 05
SoD Forms 2009 / 07
SoD Forms 2008 / 07
SoD Forms 2007 / 11
SoD Forms 2005 / 09
SoD Forms 2005 / 05
SoD Forms 2005 (more...)

Modernizing Forms Talk

The interview, I wrote about two days ago, was made in cooperation with my presentation "How to modernize Oracle Forms". And here is the video (50 minutes in german):

The link to the slides, used in the presentation, is here. It's german too, but I hope, that chapters like "Installation (more...)

DOAG interview

After my last conference-presentation I was interviewed by the DOAG. The interview is in german only and the topic is "Modernizing Forms".

Content of the interview + YouTube-Info:

Manysay about the appearance of Oracle Forms, this is no longer appropriate. Gerd Volberg from Opitz Consulting has looked at the (more...)

Oracle Forms in the Cloud – the next big thing?

The whole world speaks about working in the cloud. Why not Oracle Forms?

Why not...


Because: Oracle did it already...

Grant points to this webcast with the words: "Oracle Forms remains a key technology..."

Have fun listening to Michael and Roger

Behavior of Tab Canvases

The behavior of tab canvases ist very interesting, when your form gets more and more tabpages. Let's say, you have only three pages in your tab canvas. (Width Style Property = Fixed)
Forms automatically renders all three pages in the same size. That's what we expected.

In the next step we create a fourth tab:

If there is not enough space for all page-labels in the same size, then we see a first kind of resizing. All labels are readable. But the size of some pages is reduced.

If we create more tabpages:
At one point the label-text shrinks and (more...)

Forms Presentations at DOAG Conference 2012

And here are some tips for the DOAG Conference in Germany

Jan Peter Timmermann

Wolfgang Kriebel, Christian Kühne

My own presentation :

Perry Pakull

Stephan La Rocca

And in the afternoon we can attend at the Fusion Middleware Panel with Frank Nimphius, Duncan Mills and Jürgen Menge


Forms Modernization at Oracle Open World

Here are some tips for the Oracle "Forms" Open World 2012

Grant talks about The Future of Oracle Forms :

Lucas presentation is about The Future, too :

Mia and Grant talk together about face-lifting-tips for Forms :

More infos can be found on Grants blog and on Mia's blog

Have fun with it

Java 7 and Forms 11

Some days ago a new certification-document with an interesting info was updated:

Link to the certifications

In this excel-sheet is Forms certified with JRE 1.7.0_04+. Very good news! And now we can hope, that Forms 11.1.2 gets the same certification soon, because this is the latest version available on OTN :

And last but not least: " Please Oracle, certify Oracle Forms 10g with JRE 7 ! "