Features

  • Change easily the Look and Feel of your Oracle Forms application

  • Display and edit HTML content in multi-line Text Items

  • Have a more HTML look with your table-blocks

  • Externalize the graphical properties via a CSS file

  • Add brand new functions


  • Handle dynamic Table-blocks at runtime
    All features list


Configuration and Implementation

Configuration

In order to use the LAF project in your application, you have to do a bit of configuration:

  • Download and unzip the LAF zip file.

  • Copy the corresponding JAR file to your <DEVSUITE_HOME>/forms/java directory.

  • Update your /forms/server/formsweb.cfg file.

    As it needs the Sun Java Plug-in instead of the Oracle JInitiator, you have to create a special section that uses the Sun Plug-in.

    You also need to add the corresponding JAR file and the QTJava.zip to the archive tag (not the archive_jini).

    Create a new [laf] section as follow:

    [laf]
    # --> Forms 10.1.2 --
    archive=frmall.jar,laf_1012.jar,QTJava.zip
    # --> Forms 10.1.2.3 --
    #archive=frmall.jar,laf_10123.jar,QTJava.zip
    # --> Forms 9i --
    #archive=f90all.jar,laf_902.jar,QTJava.zip
    # --> Forms 11g --
    #archive=frmall.jar,laf_11112.jar,QTJava.zip
    baseHTMLjinitiator=basejpi.htm
    jpi_download_page=http://java.sun.com/j2se/1.6.0/download.jsp
    jpi_classid=clsid:CAFEEFAC-0016-0000-0017-ABCDEFFEDCBA
    jpi_codebase=http://java.sun.com/products/plugin/autodl/jinstall-1_6_0-windows-i586.cab#Version=1,6,0,17
    jpi_mimetype=application/x-java-applet
    separateFrame=true

    Then tell Forms Builder to use this configuration section via the menu:

    Edit -> Preferences... -> Runtime : http://xxx:8889/forms/frmservlet?config=laf

    To verify if you really use the Java plug-in, run any Forms module that implements the LAF, then  display the Java Console. The very first lines show what plugin is used:

    Java Plug-in 1.6.0_26
    Utilisation de la version JRE 1.6.0_26-b03 Java HotSpot(TM) Client VM
    Repertoire d'accueil de l'utilisateur = C:\Documents and Settings\Francois
    ...
    proxyHost=null
    proxyPort=0
    connectMode=HTTP, native.
    La version Forms Applet est : 10.1.2.3
    ***    ***
    *** Look and Feel Project v1.6.9 ***
    ...


    If you want to start asynchronous database procedure/functions via the JDBC driver, add the signed classes12.jar file in your /forms/java folder, then add it to the archive tag.

  • Copy the forms.css file somewhere on your disk (by default, it is searched in the C:/ root directory).

  • Load and execute in the database the two SQL script files located in the /script directory:

    - PKG_LAF.sql
    - PKG_DB_LAF_LOV.sql


  • Compile the laf.pll PL/SQL library, then copy the pll.plx and laf.olb files to one of the directories defined in the FORMS_PATH variable.


Implementation of the LAF in existing modules

In order to implement the required LAF objects in your existing Forms modules, a tool is shipped, that use the JDAPI to update the FMB source files.

     See the JDAPI_LAF tool


Implementation of the LAF in brand new modules

To create new modules from scratch that include the LAF features, use the Forms template shipped in the zip file (/fmb/LAF_TEMPLATE.fmb).

For more details about configuration, read the Look & Feel Developer Guide.

Oracle Forms Look and Feel Project created by Francois Degrelle