Bored of Using Old look & Feel in Oracle Forms 10g? Think again,i am going to show you the easy way to change the entire Look & Feel For Oracle Forms 10g Through Java Bean.
Perquisites :
  1. Java JRE Configured in Your Oracle Forms 10g (See my previous Post for Implementation)
  2. LAF Project Source Files     Download
  3. (Note : You will have to configure your Oracle 10g on Java JRE update 6 V.22 in order to get proper functionality)
    Extract All the files from zip package into your PC.
    • Copy the corresponding JAR file to your <DEVSUITE_HOME><devsuite_home>/forms/java directory.
    • Update your <devsuite_home>/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 to the archive tag (not the archive_jini).
      Modify the existing [jpi] section or create it as follow:
      [jpi]
      # — Forms 10.1.2 –
      archive=frmall.jar,laf_1012.jar
      # — Forms 10.1.2.3 –
      #archive=frmall.jar,laf_10123.jar
      # — Forms 9i –
      #archive=f90all.jar,laf_902.jar
      baseHTMLjinitiator=basejpi.htm
      jpi_download_page=http://java.sun.com/j2se/1.6.0/download.jsp
      jpi_classid=clsid:CAFEEFAC-0016-0000-0022-ABCDEFFEDCBA
      jpi_codebase=http://java.sun.com/update/1.6.0/jinstall-6u22-windows-i586.cab#Version=1,6,0,22
      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=jpi
    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 in PLL Folder, then copy the pll.plx and laf.olb files to one of the directories defined in the FORMS_PATH Registry variable.

2 comments :