JDeveloper 11g TP3


Posted by Hafed Benteftifa | Posted in oracle | Posted on 10-03-2008

Here I am again trying to make sense of JDeveloper for an upcoming project. This is the third attempt at using Jdeveloper in a real project since 2003.

However, it seems to me like Jdeveloper is in a perpetual state of change and each version (with its own strange numbering system) brings its lot of deprecated features and new ones that no one seem to know what to make of.

Read the rest of this entry »

Oracle Forms Technical notes


Posted by Hafed Benteftifa | Posted in Forms, oracle | Posted on 15-09-2007

I have put together some technical notes related to Oracle Forms 10g, 9i.

While they are in French, they can still be useful and understood since they contain screenshots.

These notes deal with alerts, object libraries, program unit, List items and some other basic stuff that students keep asking.

I will update as soon as I get the other remaining notes together.
How to eliminate the NULL value when displaying a Poplist

How to resolve the button that selected when the user closes a dialog
How to remove the blank lines when designing Lists in Form
How many alerts should we define in a Forms project ?
How to detect the page that was selected when switching pages in a tabbed canevas ?
How to set the PATH variable in order to avoid using the full path in your Modules ?
How to create and use a program unit in a Forms module ?
How to create and use an object library in a Forms application ?

Oracle Forms – Present & Future


Posted by Hafed Benteftifa | Posted in Forms, oracle | Posted on 14-08-2007

Of the developer tools that Oracle has delivered over the years, Forms is perhaps the most mature tool of all and has been used by thousands of developers all over the world.

However, the current situation faced by many Forms developers is quite problematic. One of the main reasons is that Oracle has adopted JDeveloper as its main tool for the Fusion strategy and one of the consequences is that the development of the Oracle Business suite has been switched from Forms to JDeveloper.

Read the rest of this entry »

Oracle Apex (HTMLDB) 2.2


Posted by Hafed | Posted in apex(htmldb), oracle | Posted on 10-02-2007

I am back now at testing HTMLDB 2.2 after last year’s tutorial. At any rate, there a number of new features with the tool although it is still missing some very obvious ones.

The most striking one is the lack of stacked, tabbed canvases. When you deal with master-detail forms, it is almost the case that you need to spread out the details info on several tabs (well at least 2 or three tabs). On the otn forum, I have seen that one post requested this feature in the upcoming release of apex 3.0 and another post stated that this tabbed canvas issue can be implemented with some DHTML tricks.

Learning to use Apex is one thing but if that also entails becoming a Javascript, Ajax, DHTML guru, then I guess we are missing the issue at hand which is managing and/or processing the database data.

Going back to Oracle Forms, the onus is on the developers and specifically the people writing the PL/SQL code
and libraries required to implement the business rules. With Apex, it looks like most of the issues that are being raised now on otn deal with the design/interface side of the application. As such, I hope that the Apex team should put all its energy toward resolving/implementing those features that made Forms such a formidable tool.

Last, a google search for HTMLDB/Apex course or lecture notes yields no results at the present time.

During the course of writing the HTMLDB (oracle ap…


Posted by Hafed | Posted in apex(htmldb), oracle | Posted on 24-03-2006

During the course of writing the HTMLDB (oracle applications express-APEX- a.k.a TAKFAH) tutorial, I was confronted to the case of the POST-CHANGE trigger (Forms-like) in APEX.

The question was already asked by a user on OTN and I went through an implementation using an idea borrowed from Carl Backstrom.

Here is the problem: you create a report based on one table. However, in one of the region, you want to retrieve the details based on one of the items from another table.

Here is the link: http://forums.oracle.com/forums/thread.jspa?messageID=1234011?

Upcoming tutorial for HTMLDB – Oracle Application Express


Posted by Hafed | Posted in apex(htmldb), oracle | Posted on 13-02-2006

I am putting the last touch on a tutorial about HTMLDB 2.0
As you might know, Oracle has now changed the name of HTMLDB to Oracle application express.

What I like about HTMLDB is the ease of development and the fact that you can put together a working app in a very short time. Unfortunately, there does not seem to be a lot of tutorials on this tool (the OTN page for HTMLDB lists a few but there no single end-to-end app developed with HTMLDB).

At any rate, it will be posted here very shortly.

Basic features for the IDE- Oracle notes designer


Posted by Hafed | Posted in Forms, oracle, Wiki | Posted on 28-12-2005

I am working on the features to be included on the IDE. Checking sourceforge.net, I found several interesting open source packages. The closest to what I envision for the code generator is middlegen(http://boss.bekk.no/boss/middlegen/).

Now, for the notes feature itself, I came across http://www.to-java.com/ which I found on the oracle otn section (migrating Lotus notes apps to J2EE, http://www.oracle.com/technology/oramag/webcolumns/2003/techarticles/lin_tojava.html). That’s exactly what I think is the closest to a Forms, views paradigm for an Oracle-notes application.

As far as the IDE is concerned, it is going to be a Java Swing based interface. For the time-being, I am checking Sun Netbeans (http://www.netbeans.org/) and Oracle Jdeveloper.

At any rate, I don’t want to get too deep in extra features at this point. The basic point is to get an MVC application with the capability to display Views and Forms.

What about a Development tool à la Lotus Designer


Posted by Hafed | Posted in Forms, oracle | Posted on 09-12-2005

Is there any Oracle extension or a development tool for Oracle that works the same way as Lotus Designer.
Basically, a tool that allows the quick setup of an interface with views on the left pane and a list of documents (records) on the right side. Actions in this case will be related to triggers.
This can be done with Oracle Forms but it is quite tedious. Did anyone come across such a tool ?
I am aware of most of the Oracle development tools (Oracle Designer-Forms- HTML DB etc …) but I still did not come across such a tool.
Most likely, JDeveloper will allow such a setup but this will require a significant programming load.
Lotus notes is amazing as far as the presentation of data is concerned. Anyone with a basic understanding of document management can quicly setup a visual interface that can present the data within the documents in a very easy to understand format. What is most important is that the end user can quickly start working on the documents within the Notes database.
Oracle still does not have this capability as far as I know and if anyone can point to a similar tool, it would help a lot.

Random thoughts and Tips about ORACLE Tools


Posted by Hafed | Posted in oracle | Posted on 09-12-2005

I had to start somewhere but after gathering a huge amount of links, tips and documents about Oracle Tools, I believe it is about time for me to start putting these into paper (oops… I meant a blog).
My primary interests for the time being are Forms and Designer 6i/9i. I teach both courses at a College in Montreal, Quebec- Canada.
While I experimented with Oracle JDeveloper in 2004, I did not have a chance to do a thorough review of the product at that time. This week, I downloaded the latest version and I plan to put it to work in the coming few weeks.
I am thinking about preparing some lecture slides for JDeveloper, similar to the ones we have for FORMS. I checked the book Oracle JDeveloper 10g Handbook by Avrom Roy-Faderman, Peter Koletzke, Paul Dorsey. It is a thick book but seems to be really concise.