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 :
- Java JRE Configured in Your Oracle Forms 10g (See my previous Post for Implementation)
- LAF Project Source Files Download
- (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.sqlCompile 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.
under wich user should those scripts be run?
ReplyDeletefor 11g forms laf is support?
ReplyDelete