Collected from: http://sheikyerbouti.developpez.com/index_en/
Introduction........................................................................................................3
Color definition table ........................................................................................3
Colors.pll.............................................................................................................4
Color selection screens .....................................................................................5
PL/ SQL-based dialog...................................................................................6
Java Bean-based dialog.................................................................................7
Changing Forms menu colors..........................................................................8
Forms test module.............................................................................................8
Setup Instructions .........................................................................................9
Summary.............................................................................................................
Intoduction
The solution introduced in this paper allows Oracle Forms application users to
customize the colors used in a form. A color selection screen is available for the
following Forms items:
x Canvas color
x Tab canvas color
x Prompts (and tooltips) color
x Background buttons color
x Text buttons color
x Background current record color
x Text current record color
Individual user preferences are stored in a database table which holds a table row
for each user. The application user is identified by a unique value of type
NUMBER. This value is read when loading the first screen and thereafter is sent as
a parameter in each subsequent call to a screen (CALL_FORM, OPEN_FORM,
NEW_FORM).
The customized color defined for each item is applied during Forms startup by
calling a PLSQL function in theWHEN-NEW-FORM-INSTANCE trigger
The PLSQL function is located in a Forms library, FRORUV SOO, and loops through all
visible items, setting the colors through visual attributes.
Though this paper focuses on Oracle Forms 10g, the provided PL/ SQL code
examples also work with earlier releases of Forms. All source examples are
available at otn.oracle.com/ products/ forms.
Color Definition Table
The table that holds the customized colors for a user must contain at least one
row, with COD_UTIL = 0, which contains the default values (RGB format) for
users who don’t use a customized color scheme.
CREATE TABLE UTIL_PREFS
(
COD_UTIL NUMBER(5) PRIMARY KEY, -- User code
C_FOND VARCHAR2(20 BYTE), -- color of canvas
C_LIBELLE VARCHAR2(20 BYTE), -- color of prompts
C_CADRE VARCHAR2(20 BYTE), -- color of tab canvas
C_BOUTON VARCHAR2(20 BYTE), -- color of background buttons
C_TBOUTON VARCHAR2(20 BYTE), -- color of text buttons
C_CURREC VARCHAR2(20 BYTE), -- color of background current
-- record
C_TCURREC VARCHAR2(20 BYTE) -- color of text current
-- record
) ;
INSERT INTO UTIL_PREFS ( COD_UTIL, C_FOND, C_LIBELLE,
C_CADRE, C_BOUTON, C_TBOUTON, C_CURREC,C_TCURREC) VALUES (
0, ’r128g128b192’, ’r255g255b64’, ’r64g128b255’, ’r255g192b255’,
’r64g64b192’, ’r128g255b255’, ’r128g128b255’);
A Forms color selection dialog is provided in the sample code of this solution and
handles the user specific table inserts and updates.
&2/256 3//
The colors.pll library contains the PL/ SQL code to customize the color of visual
objects in Forms at startup, at enter query (which color all queryable items with the
color specified in the VA_QUERY visual attribute), and after execute query to
recall previous colors.
The colors.pll library needs to be attached to the Forms modules used in a Forms
application. Copy the *53B&2/256 group from the object library FRORUV ROE
The *53B&2/256 group contains the following objects that need to be added to
the Forms module:
x A form level trigger WHEN-NEW-FORM-INSTANCE for the
colorization function call
x A form level trigger KEY-ENTQRY for the colorization in ENTERQUERYmode
x A form level trigger KEY-EXEQRY to re-set the initial colors after
execute query
x 3 alert boxes
x A parameter 87,B,' for handling the ID that uniquely identifies the user
x Visual attributes for colorization of objects
The color.pll library contains 2 PLSQL procedures and 1 PLSQL package:
x 6WDUWBTXHU\ - procedure to color queryable items in ENTER-QUERY
mode
x (QGBTXHU\ - procedure to re-set the initial colors after EXECUTEQUERY
PKG_COLORS PACKAGE
o Global variables for the colors read from the UTIL_PREFS table
o Global variables to translate Strings used in the COLORS.FMB
and COLORS_J.FMB screen
o Procedure “Paint”, which is the main procedure called during the
Forms instance startup
o Procedure Set_colors
Items that are not navigable are colored with a light gray background. All mandatory
items are indicated by a bold prompt. You maywant to customize the PLSQL package to
use your preferred indicators.
To preserve the initial colors of items, start the TOOLTIP_TEXT with the NCC (No
Change Color) characters. These 3 characters are removed when the program is executed
to insure a correct tool tip display
COLOR SELECTION SCREEN
Two Forms screens are provided with this whitepaper, as well as samples that
allow the user to customize the application color for that instance:
x PL/ SQL based dialog (COLORS.FMB) - This screen uses native Forms
code to render the color selection dialog.
x Java Bean based dialog (COLORS_J.FMB) – This screen uses the Color
Picker Java Bean sample from the Oracle Forms demos. Using the Java
Bean does allows the user to choose from more colors than the PL/ SQL
based screen, but requires the bean JAR files to be deployed with the
application.
All screens can be accessed through a menu option or buttons. All that needs to be
done is to pass the user code in the UTI_ID parameter. Never transmit the 0 code
which is the per-populated default code
PL-SQL Based Dialog
To customize the color of a visual component in Forms, click the corresponding button
of the object to change the color of and click on one of the 64 color cells. Save the screen
(Ctrl+S) to store the new colors or just exit (F4) to cancel anymodification
JAVA BEAN BASED DIALOG
To customize the color of a visual component in Forms, click the corresponding
button of the object to change the color, then select the color from the Bean
selection dialog. Save the screen (Ctrl+S) to store the new colors or just exit (F4)
to cancel anymodification.
In order to run the screen with the Java Bean component, you need to download
the colorpicker.jar file, which is a part of the Oracle Forms 10g demos available on
the Oracle TechnologyNetwork (OTN)1
x To configure the Bean, copy the file colorpicker.jar into the
<ORACLE_HOME>/ forms90/ java directory
x Edit the Forms formsweb.cfg configuration file located in
<ORACLE_HOME>/ forms90/ server/ and add the colorpicker.jar file
to the JInitiator archive tag
[myColorfulApp]
form = myForm.fmx
…
archive_jini=f90_all
...
1 http:/ / download.oracle.com/ otn/ other/ general/ forms10gdemos9_0_4_2.zip
Changing Forms Menu Color 
