Articles Oracle Forms, PL/SQL, Java, J2EE
With the old C/S versions, the TEXT_IO package allowed to manipulate text files on the client machine. Since the Web versions, this package allows to manipulate text files on the Application Server machine. To allow developers to manipulate text files...
Here is a Java Bean that allows to use regular expression 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 regular...
The PJC & Java Bean store get more and more entries. The blog engine does not offer the best way to easily navigate through the articles. I have added another page that allows to browse all the entries through a tree menu: You can display this new page...
In this second chapter, the bean is able to etablish the correspondance between the Java components and the Forms module's items. When the mouse enter an item, the background color is changed, then an event is sent to Forms to indicate which item is concerned....
Sometimes I see questions about how to get the file list of a local directory. The standard answer is to proceed a Host() command that use the DIR command with a redirection to a file: Host('cmd /c dir /b c:\*.jpg > c:\list_file.txt'); When the file is...
Here is a collection of PJCs that allow to have multi-line labels and tooltips. The tooltips can have a nice decoration like Java gradients and be displayed anywhere on the screen. All the properties can be set within the Tooltip item property. So it...
A new White Paper has just been published on OTN. It presents a new tool that allows to give a new Look and Feel to the Forms applications. I would be pleased to "open " the code to the community, then allow everyone who feels concerned by the evolution...
Here is a Java bean that allows decorating the Forms application elements. It becomes very easy to change all the fonts of a Forms application at runtime. As you can see, it is possible to change the menu bar, window title and status bar font and colors....
The 1.2 version of the Look and Feel project is available. It comes with a new feature that allows decorating some unusual elements like menu bar, menu option, window caption or status bar. You can also change the font properties, foreground color and...
It is not the first time I see questions on forums about how to calculate a formula that is stored in a string. Here is a Forms sample that demonstrates how to achieve this task. The formula (3rd line in this sample) can contains real values as well as...
Hello folks, The Zappa Plays Zappa is on tour again with plenty of dates in Europe. If you keep a so great memory of the genious father's (Frank) music, or want to discover a piece of his colossal oeuvre, let come and enjoy listening his music again played...
Here is a way that allows following the progression of a stored procedure. The following code is used to create a sample stored procedure to test. It uses the dbms_application_info.set_session_longops to insert "tags" that can be read by the Forms application....
Here is a PJC that allows showing/hiding scrollbars on a multi-line Text Item. Actually, there is no property to show the horizontal scrollbar on a Text Area. Get the JAR file here Get the Forms sample here (9.0.2) The Java code is as simple as the following:...
Here is a Java Bean to handle CLOB/NCLOB database columns in a Forms application. It is a more elaborated version of a previous one, which was based on a PJC (VTextArea). Unfortunately, the PJC was no able to handle huge texts, and often "froze" with...
This Java Bean allows to process massive updates to the Forms source files (.FMB) through an XML input file. 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 the work...
Here is a sample dialog that allows to extract the content of a table-block to an HTML code. You can extract all the rows of the given block or only a range. It uses the package (PKG_HTML_TABLE) to extract the data to the HTML code. The function needs...
These days, we received two new Java Beans to add to the forms-pjc-bean library A first one from Mark Striekwold about another solution to display a full Web browser with Flash animation, and documents like Powerpoint, MSWord or MSExcel inside the Forms...
I saw a blog entry, today, about the Google Chart APIs, and it immediatly made me thinking about the enhanced HTML browser or the other enhanced HTML browser Forms Java beans to render simple graphics in the application frame. Of course, you can display...
To mark the third anniversary of the forms-pjc-bean site, I am pleased to launch a Forms Java Bean contest . To take part, all you need to do is to show a developed Forms application that contains an interesting, innovative, or just plain "cool" use of...
I have just added the keyboard navigation function to the Scrolling Image Panel new function. You can, then, navigate through the images using the Left, Right, Home and End arrows on the keyboard. As it is really a minor modification, I decided not to...
Hafed Benteftifa has just released his FRITE - Forms Rich Text Editor - alowing the Oracle Forms application to edit HTML content. This is just the kind of Java Bean, developers and end-users were waiting for years ! Don't waste any more time, run and...
The Forms Java Bean contest is over, and it is time to publish the result: The winner is Md. Mehbub Islam with his Scanner Bean Congratulation! Others on the podium are Hafed Benteftifa's FRITE and Vijaynath Nair's Autocad Integration Bean (2nd), and...
Hello, I have just finished to design the new site to host the Forms Look and Feel Project. I hope you will enjoy it, and think to send me screen-shots of your LAF implementation to feed the new image gallery tab ;o) The URL is still the same. Maybe you...
Oracle Forms: LongBridge Consulting's NEW JavaBeans Image/Document Capture, Storage, Retrieval, Viewing & Manipulation 4 New, Improved & Productive Image/Document JavaBeans for your Real-World Document Management needs !!! ImageViewerBean for Viewing...
Develop your Oracle Forms application for one screen resolution, then run it in full screen with no visual change for any other resolution! This new commercial tool is capable of moving and scaling every Canvas and Item at runtime to fit the new window...
