This is a bunch of tips and techniques related to Oracle PL/SQL and Forms.

The implementation class of the Bean Item
oracle.forms.jvr.TimeZones
The Java code
TimeZones.java
The methods you can call
FBEAN.INVOKE ('BL.BEAN',1,'setPaisOrigen','ES');
FBEAN.INVOKE ('BL.BEAN',1,'setZona','America/Buenos_Aires');
:BL.DATE := FBEAN.INVOKE_CHAR ('BL.BEAN',1,'fechaHora','');
The sample dialog
. Download the TimeZones.zip file
. Unzip the TimeZones.zip file
. Copy the TimeZone.jar file in your /forms/java/ folder
. Add it to the archive and archive_jini tags of the /forms/server/formsweb.cfg file
. Open the TIMEZONES.fmb module (Oracle Forms 10.1.2)
. Compile all and run the module
The jar file must be signed
The jar file provided with the .zip file are already signed
For any question concerning this bean, send a mail to Jesus at vallejo.jesus@gmail.com.