This is a bunch of tips and techniques related to Oracle PL/SQL and Forms.
Purpose Here is a Java Bean to handle CLOB/NCLOB database columns in a Forms application. It needs a database package to read the LOB data from the database, split into chunks in order to send them to Forms and finally to the JavaBean, and also to send...
This Java Bean allows to process massive updates to the Forms source files (.FMB) through an XML input file. Purpose The goal is to hide the complexity of the Java/JDAPI stuff for those people that do not have time/skill to implement this Java API. All...
Purpose Here is a Java bean to dynamically handle menu options at runtime. You can dynamically add, remove, enable, disable, show and hide menus and menu options. The Java code DynamicMenu.java The implementation class of the Bean Item oracle.forms.fd.DynamicMenu...
Purpose Here is a Java Bean from Casey Bowden to get back print features lost in Oracle Reports converting to web environment. I. Problem One : Point Of Sale (POS) clients is slow to print. After converting reports from client/server to the web environment,...
Purpose Here is a Java Bean that allows handling frames at runtime. Almost everything about frames can by handled. With this single bean, you can create and handle as many frames as needed. This Bean needs at least the Sun Java plugin 1.4 What you can...
Purpose Here is a Java bean that allows decorating the Forms application containers. It becomes very easy to change all the fonts of a Forms application at runtime. You can set the Font Family, weight and size, foreground and background color on the following...
Purpose Here is a Java Bean from Casey Bowden to get the status of a long report and to cancel it if needed. I. Problem One: Report Status When running Oracle Forms and Reports in client/server, users knew the status of the report they were running. After...
Purpose Here is a Java bean that allows the Drag 'n Drop within a Swing JTree item. This bean is proposed by Minas Lyrakis from Greece . This bean uses itself the DispatchingBean of Tom Cleymans . (so it needs the sun Java plugin 1.4 at least) You can...
Purpose Here is a Java Bean that allows to paint the current canevas with a Java gradient. It needs the JRE 1.4 (Sun Java Plug-in) The Java code PaintCanevas.java The implementation class of the B ean oracle.forms.fd.PaintCanevas The methods you can call...
Purpose Here is a text item's PJC that can be used in multi-records Forms tables. It allows to have a coherent behaviour in a multi-record table for items that record number are greater than the number of records displayed. In the standard way, you can...
Purpose Here is a Java bean that allows to Drag 'n Drop between Forms items. You can Drag 'n Drop between mono and multi-line text fields and between images . Because the "real Java" Drag 'n Drop is not implemented in the Forms application, This one is...
Purpose Here is a Java bean that allows querying a POP3 server It uses the commons-net-1.4.1.jar JAR file from the Jakarta project. http://jakarta.apache.org/site/downloads/downloads_commons-net.cgi . This bean does not use all the functionnalities of...
Purpose Here is a PJC that allows doing some basic operations on a Text Item. You can apply styles on the selected sub-text and also view the HTML result in a browser window. It is a "light" component that does not render the HTML result itself, but has...
Purpose Here is a PJC for textfields that allows to have a blinking behaviour. This behaviour could be easily applied to other kind of items, like Command buttons for instance. The Java code BlinkTextField.java The implementation class of the Text Item...
This tool allows the look of your Forms application to be separated from the functional design. All the decoration elements are read from an external CSS file, as currently done with HTML pages and so both HTML and Forms applications can share a common...
This Bean contains a functionality to change Font information on Form Items. The current Font properties of the Item choosen in the ComboBox will also be reflected in the Beans. Available Functions: Bold, Italic, Strikethrough (only on TextItems), Underline...
Purpose Here is a package that allows the dispatching of events from Java Beans to Forms on Beans that extend VBean, beans that use the FBean package and also PJCs ! No, you are not dreaming and there is no mist on your glasses, a PJC that dispatch event...
Purpose Here is a Swing JButton that overloads a standard PJC's button. It needs the JRE 1.4 (Sun Java Plug-in) It allows to have a standard Forms button with some nice decoration features. You can apply a gradient color, set rounded borders, justify...
Purpose Here is a collection of PJCs that allow to have multiline labels and tooltips. The tooltips can have a nice decoration like Java gradients, and be displayed anywhere on the screen. It needs, at least, the Sun Java plugin 1.4 to run. It won't run...
Purpose Here is a Java bean that allows to start programmes on the client machine, then capture the standard/error output. It could be used if you don't want to install or use the Webutil library. If you target to use parameters that contain blanks, separate...
Purpose Here is a Java bean that allows to have an enhanced Web Browser. It is a full Web browser that can handle Javascript and display Flash animations. The material comes from a sourceforge project: http://sourceforge.net/project/showfiles.php?group_id=170904...
Purpose Here is a Java bean that allows to capture the mouse events and display the properties and methods of the clicked component. Right-click on a component to display its properties and methods. The Java code HandleMouseEvent.java The implementation...
Purpose Here is a Java bean that allows to send emails with html body and attachments. It is a modified version of the Oracle Forms Demo's javamail bean. The javamail Oracle Forms Demo allows to send emails with attachments located on the server side....
Purpose Here is a Java bean that allows to chat on a Forms application It uses a modified version of the socketserver sample. The list of chatters is held by a database table (CHAT) and a database package (PKG_CHAT) that get and dispatch the messages...
Purpose Here is a Java bean that allows to capture the mouse events and display the properties and methods of the clicked component. In this second chapter, the bean is able to etablish the correspondance between the Java components and the Forms module's...
