This is a bunch of tips and techniques related to Oracle PL/SQL and Forms.
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...
Lire la suite
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....
Lire la suite
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...
Lire la suite
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...
Lire la suite
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...
Lire la suite
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...
Lire la suite
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...
Lire la suite
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...
Lire la suite
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...
Lire la suite
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....
Lire la suite