This is a bunch of tips and techniques related to Oracle PL/SQL and Forms.
Purpose Here is a Java bean that allows to transform a Forms module into a socket server. This way, it can receive messages from the outside. - In this example, the messages are sent through a telnet session. In this sample dialog, I have opened a telnet...
Purpose Here is a Java Bean that allows to use regular expressions with the Sun Java Plug-in. Regular expressions have been introduced in the Oracle database with the version 10g. For those who still use a previous version, this Java Bean allows to use...
Purpose Here is a PJC that allows to set the cursor from any image stored in the jar file. This PJC extends VTextField, so you must set the Implementation Class name on a Text item. The Java code JTextFieldIcon.java The implementation class of the Bean...
Purpose Here is a Java Bean that allows to start asynchronous jobs from an Oracle Forms application. When you execute a stored procedure or function within a Forms application, the end user cannot get the hand until the procedure/function is completly...
Purpose Here is a Java Bean that allows to read, display and write images. ( See the last evolution of this solution here ) When you load an image within Forms with the Read_Image_File() built-in, you can notice a certain lack of quality, both in the...
Purpose This is the part II of the utilities Java Bean. A second tab allows to manipulate some Text field properties. . You can set dynamically the maximum of charaters the user can enter. . You can also set the cursor blink rate and the cursor style....
Purpose Here is a Java Bean that allows to write/read files on the client machine without installing Webutil. The Java code clientfile.java Register the Bean The bean must be registered before you can call its methods. Because the Bean cannot be registered...
Purpose This Java Bean is the first step to build a utilities' bean that will group several functionalities. In this introduction, the Java Bean starts with a "Font" chapter that allows to get the bounding box for any string of any font, and also to get...
Purpose This is a JavaBean that allows to handle a "HTML Map" in a Forms application. The Java code MapComponent.java zone.java The Implementation Class property oracle.forms.fd.MapComponent The properties you can set Set a polygonal area Set_Custom_Property('BL.BEAN',1,...
Purpose Let's have a little bit fun and break the wall with this Oracle Forms JavaBean. The purpose of this research&development unit is only to show that the VBean class allows to do anything in an Oracle Forms application. You are able to build a complete...
Purpose This is a JavaBean that allows to play sound files from the file system. The Java code sound.java soundlist.java soundloader.java note : the jar file must be signed Implementation Class property oracle.forms.fd.Sound The properties you can set...
Purpose This PJC extends default button functionality to show both icon and label. By Oleg Tishchenko The Java code Get the source code here Forms configuration . Copy the lablediconbutton.jar file in the /forms/java directory . Edit the /forms/server/formsweb.cfg...
Purpose This is the second part of the chapter on "how to create component at runtime". In this chapter, let's see how to create some titled-framed text items Click here to get the full format image On the Forms module displayed on this screenshot, all...
Purpose This JavaBean allows to find and handle the form windows (current window and MDI window). With this handle, you can set some particular properties like the following: . setMovable()* . setClosable()* . setMaximizable()* . setMinimizable()* . setModal()*...
Purpose This is a Java Bean that allows to add buttons on the current Forms canvas at runtime. The Java code Get the source code here Forms configuration . Copy the additem.jar file in the /forms/java directory . Edit the /forms/server/formsweb.cfg file...
Purpose Here is a (very) simple HTML browser. This JavaBean component allows to browse some simple HTML pages inside the Oracle Forms frame. It may be a good way to browse into local documents, like documentation html pages. You can click on the hyperlinks...
Purpose This is a Javabean component that displays a JTable inside/outside of a Forms module. It allows saving the data modified through the JTable into the database. (A special version - fjtable16.jar - permits to sort the JTable on any column, if you...
Purpose Here is a Java Bean component to read the Forms applet parameters The java code Get the source code here Forms configuration Copy the appletproperties.jar file in the /forms/java directory Edit the /forms/server/formsweb.cfg file to add the jar...
Purpose This is a Javabean component that allows to intercept each key typed in a text field Then, there is no need to use a Forms timer to intercept each key typed. The java code Get the Java code here Forms configuration . Copy the keytyped.jar file...
Purpose This is a Javabean component that allow to enter a value from an input dialog box The java code package oracle.forms.fd; import oracle.forms.handler.IHandler; import oracle.forms.properties.ID; import oracle.forms.ui.VBean; import javax.swing.JOptionPane;...
Purpose This is a Javabean component that allows to replace the internal Oracle Forms’ timer The java code package oracle.forms.demo; import oracle.forms.handler.IHandler; import oracle.forms.ui.CustomEvent; import oracle.forms.properties.ID; import oracle.forms.ui.VBean;...
Purpose This bean allows to display buttons with a html content. The content can be text or image. On the screenshot below, we can see a button with an image that comes from an internet url () The java code package oracle.forms.fd;...
Purpose When you want to load images from the client machine to the database, you would like to choose the right image file with a preview of each image. This is a Javabean component that allows to display a JfileChooser dialog box with image preview....
Purpose This bean allows to display a Jslider component in your Forms application. The java code package oracle.forms.fd; import java.awt.*; import java.awt.event.*; import java.util.StringTokenizer; import javax.swing.JSlider; import javax.swing.event.ChangeEvent;...
Purpose The Show_Alert() Forms built-in allows to display any message in a popup modal window. This built-in is limited to a maximum of 255 characters displayed. This limitation cannot allow to display huge messages like trace/log message. This is a Javabean...
