APEX presentation- Montreal march 18, 2010

5

Posted by Hafed | Posted in apex(htmldb), Forms | Posted on 19-03-2010

There were very good news yesterday at the APEX presentation made by Oracle and the team behind sie-solutions (website). The most interesting features that will be available in the upcoming 4.0 release were discussed in the morning sessions.

In the afternoon, there were 6 speed training sessions related to the following features:

  • Graphic look for an APEX application
  • Preparing an APEX application for smartphones
  • JQuery in APEX
  • Plugins
  • Dynamic actions
  • How to break down a database using poor programming habits within APEX

For Oracle Forms developers, the most interesting feature is what is called dynamic action, another term for trigger. I already raised that issue in this post a while back. In essence, I was concerned that in order to mimic a trigger behavior in APEX, you had to resort to javascript which a number of people are not comfortable with. Now, with the wizard in the 4.0 release, you should be able to implement some very interesting features in APEX.

As far as plugins are concerned, it is the way to go if APEX is to grow. However, I raised an issue dealing with the fact that most companies won’t use a plugin unless it is certified free from trojan, virues etc. The reason is that APEX is deployed in the database and as such a well (bad usage) crafted plugin would open the data in the DB to external mining. In this case, I think a plugin store similar to Apple store or Google market should be the way to go. Who is going or willing to manage it ?

Anyway, excellent presentations by the team behind sie solutions.

Garnering interest for Oracle Developer day in Montreal, Canada

5

Posted by Hafed | Posted in oracle | Posted on 02-03-2009

The last week has been quite hectic with the release of Frite and the new improvements I am adding to the google map bean. Glancing over the Oracle forms OTN pages and Grant’s blog, I was a bit feeling down not seeing Montreal on the Oracle developer’s circuit.

I know from facts that the local Montreal Oracle Forms community is quite large and it occured to me that we can get an Oracle Developer’s day scheduled here. So, if you are a Forms or Java developer interested in seeing Grant and his friends here in Montreal, Canada, show us JDeveloper and how the Oracle Forms functionalities map in JDeveloper, please send me an email to info [at] degenio.com and leave a commment below.

In the email, please state your name, company if you are working and how long you have been using Oracle Forms and your interest in attending such a session.

Please understand that there is no guarantee there will be a dev day in Montreal very soon, but if I can get a sufficient number of interested developers, we can make a point with Oracle.

Oracle Forms to Oracle APEX conversion update

0

Posted by Hafed | Posted in apex(htmldb), oracle | Posted on 12-02-2009

David Peake, product manager for Oracle application express, has posted an announcement related to the availability of APEX 3.2.

Forms Conversion  is one of the features that is available in this release.

The free hosted “development” environment on http://apex.oracle.com , which is open to all developers, has been updated to APEX 3.2. That should give us an easy way to try out APEX.

I have a couple of hard to convert forms module full of triggers, program units and database calls that I will be running through the converter once I get a free moment. I am too busy now with the release of Frite.

A migration dashboard with Forms JavaBeans

4

Posted by Hafed | Posted in Forms, oracle | Posted on 20-09-2008

In order to follow the migration efforts from 6i to 10g, I quickly put together a dashboard that shows the four states : migration-testing-correction-acceptance for the modules in our application.

On the left side, we can click on the buttons to show the global stats, stats per analysts, stat per application and the modules that are problematic.

Oracle forms migration dashboard

The gauge is a Javabean that I put together following an example I found on the OTN network. There are a number of properties that can be set on this javabean. I really did not spend that much time on the graphics part of the gauge but eventually I will have to do it since our application itself might include some versions of this gauge in the future.

Oracle forms PJC - gauge

There is also a timer (invisible on this canvas) that I borrowed from the Oracle foms 10g demos. The timer is set to 20 min and a custom event trigger is set to query a table that holds the module’s names and their states.

Oracle Forms to Oracle APEX migration

5

Posted by Hafed | Posted in oracle | Posted on 11-08-2008

Last week, one of our senior DBAs made a comment  regarding our current migration. Essentially, he was referring to Oracle APEX (formerly HTML-DB) and whether we looked at Forms to APEX conversion.

Management decided a while ago that we will be migrating to Oracle Forms 10g given that the in-house expertise is mostly Oracle Forms.

Read the rest of this entry »

Oracle reports 10g – local printing problems

4

Posted by Hafed Benteftifa | Posted in oracle | Posted on 30-07-2008

In the course of adapting our reports and submission forms to 10g, some of our users asked for a specific request. In version 6 of our application, users can either request a screen preview or print directly to the local printer.

In 10g, the local feature is lost because the processing is now done in the middle-tier. There are a number of alternatives, each having its own advantages and drawbacks.

Read the rest of this entry »

Week2 – Migrating a mission-critical Oracle Forms 6 application

4

Posted by Hafed Benteftifa | Posted in Forms, oracle | Posted on 27-07-2008

Here we are at the end of the second week in the migration of a mission-critical Oracle Forms 6 application. The main points we dealt with are:

  • AIX file transfert and compile processes
  • LOV visual appearance (differences between 6 and 10g)
  • Report rdf structure search in a batch mode from a keyword-based file

Read the rest of this entry »

Generating FormsDoc and FMB module compare functionality

0

Posted by Hafed Benteftifa | Posted in Forms, oracle | Posted on 14-06-2008

For the last two weeks, I have been working on ironing out the two functionalities in MouliForms that I think are very useful for an Oracle forms developer:

  • Generating documentation on the Forms modules that make up an application. This is similar to Javadoc for those that are familiar with JAVA. In this case, I choose to generate an HTML page for each module. This will give the liste of Program Units (procedures, function and packages) linked thru an index page.
  • FMB module compare: In most cases, we have a before and after version for the same module and we want to have an exact picture of what has changed as far as the objects are concerned.
    While the basic functionality is there (changes are reflected in Red), I am still having some troubles with object properties. It seems to me that the developers at Oracle did not lay out a proper mechanisms for object-property categorization.
    I managed to rewrite the whole property palette (with the BEFORE and AFTER columns) but there are still some unwanted properties that do appear at the wrong place-object.