Francois Degrelle's blog about some Oracle technologies

It is not the first time I see, on forums, questions about how to restrict, at runtime, the number of characters a user can enter in a text item. The solution consists in understanding that every standard Forms widget has an associated PJC that can be handled by the Set_Custom_Property()...

The last 1.3.4 version of the Forms L&F is available

This PJC is a workaround to the issue defined in the bug 3867157 on Metalink. It allows having the same behaviour on the Web that the one it has on the C/S version. The When-List-Changed trigger would fire only when the mouse is clicked or when the Enter key is pressed, but not when...

Hello there, I would be pleased to present the brilliant work of a nice French person, who has developped a library, capable of encapsulating the so complex OCI interface. It is a powerful workaround for those C programmers that are not totally satisfied with the...

The Forms Swing JTable Java Bean has been updated to correct some issues when used with the JInitiator plugin. If you are using this plugin, re-load the new jar file from the article.

Here is an article showing how you can have  dynamic LOVs in your Forms modules. It allows to define 1 to 5 different LOVs that can display 1 to 9 columns. Completely dynamic ! read the article

I have just uploaded a short video that shows how to build a brand new Form module including the Look & Feel from scratch. You can get the .avi file from the Look&Feel documentation home page, or directly from here.

Here is a Java Bean that allows sending back to the Forms application each key pressed in any Text Item.    Read the article

Here is my present for X-MAS, a Java bean that allows to choose a date from a Java swing calendar.   The Java calendar itself is from Kai Toedter - Released under GNU Lesser General Public License - www.toedter.com See the article.

Save energy with the new BLACKLE Google site.

Hello there, If you like motorbikes, you'd better have a look at this powerpoint file. It is amazing to see what people could make with a few small pieces!

Here is a sample dialog that allows to extract the content of a table-block to an HTML code. You can extract all the rows of the given block or only a range. It uses the package (PKG_HTML_TABLE) to extract the data to the HTML code. The function needs the block name and two non...

Steve Cosner, on the OTN Forms' forum explains how he successfully installed Forms 6i on Windows Vista.

It seems that many people would like to apply massive changes within their existing Forms applications, but do not have the skill (or the time) to deal with the Oracle JDAPI stuff. I have started a project targeting to do this kind of massive changes from a JavaBean, so a simple Forms...

It is frequently asked how to load a BLOB table column from the content of an external file. This can be achieved by using the DBMS_LOB package's functions. Sometimes it is also useful to extract the BLOB content back to a file. Here is a procedure that achieves this task:...

Here is a Java Bean to handle CLOB/NCLOB database columns in a Forms application. It is a more elaborated version of a previous one, which was based on a PJC (VTextArea). Unfortunately, the PJC was no able to handle huge texts, and often "froze" with text length greater...

Here is a Java Bean that allows reading, displaying with scaling and writing images. This bean is a more elaborated image handler (than this one). It allows scaling images to fit the target item size, and includes a FileChooser with image preview dialog. Read...

I frequently see questions on Forums about how to handle a cursor  with a dynamic Where clause. Oracle Forms has a special package named : EXEC_SQL that allows using dynamic SQL in the Forms application. Here is a sample dialog that queries the EMP table with the...

NOW, THEREFORE, I, SHEILA DIXON, MAYOR OF THE CITY OF BALTIMORE, do hereby proclaim August 9, 2007 as "Frank ZAPPA DAY" in Baltimore and do urge all citizens to join inthis celabration. Frank Zappa had still a statue in Republic Tcheque, a street in Berlin and now has a special day in the...

I've just discovered that Laurent Schneider has published a book about "Advanced Oracle SQL Programming". As I already know and have learned from him, I am pretty sure this book would be a gold mine.