Articles Oracle Forms, PL/SQL, Java, J2EE
Once having set up new stats on the Oracle Forms Look and Feel project, here are the results after two months: The world's champion is clearly Germany ! Don't know if it reflects the German Oracle Forms market (and I know that Germany IS a big Forms market...
The new Forms Look and Feel Project 1.4 version is out with an HTML Scrolling Panel. Like a Scrolling Banner, it is usefull to display big information in a small room. You can display external HTML pages but also single text as well. This new version...
Here is a Forms 11g Pluggable Java Component that allows sending back to the Forms application each key pressed in a Text Item (single or multi-line). As you know, the older versions (Forms 10g and Forms 9i) did not allow PJCs to send back custom events...
Following the request of LAF users who claim that Alert Boxes and LOVs do not support the L&F decoration, I have implemented these new features in the next 1.3.9 version. Personally, I would never have thought about re-writing the LOV stuff because the...
Just to remember, The Enhanced HTML browser bean allows showing almost everything in its window. In my sample, I showed only HTML content, but keep in mind that you can also use the file:// protocol to display any kind of files. see the full size image...
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 Drag 'n...
There are some standard objects in Forms that you cannot handle at runtime. Frames are one of them. 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...
Here is a Swing JButton that overloads a standard PJC's button. It allows to have a standard Forms button with some nice decoration features. You can apply a gradient color, set rounded borders, justify the label and also have a shadow behind the label....
I have just read the Jeff Moss article concerning Hex to decimal conversion and vice versa. In this article we can find some great conversions routines. This is one that allows to convert hexadecimal numbers greatest than 255 to a decimal format: CREATE...
ON NUMBERS This function allows to make two types of action on a number: - Keep the number of wished decimals (precision > = 0) - Centre the whole part of a number in a range (precision < 0) Example of preservation of the decimal part
SQL> select...
This is a small function that allows to extract tokens from a string. CREATE OR REPLACE FUNCTION Split ( PC$Chaine IN VARCHAR2 , -- input string PN$Pos IN PLS_INTEGER , -- token number PC$Sep IN VARCHAR2 DEFAULT ',' -- separator character ) RETURN VARCHAR2...
This is a PL/SQL procedure that allows to display the integrity referential path for a table. The result on a single table looks like the following : ------------------------------------------------------------------- Integrity referential constraints...
This a small function that allows to sort the content of a string (ASCII sort).It use a collection or records to do the job: CREATE OR REPLACE FUNCTION sort_string(pc$string IN VARCHAR2) RETURN VARCHAR2 IS TYPE typ_rec IS RECORD(lettre VARCHAR2(10), nbre...
It is not the first time i see some posts on forums that ask: How can I make a dynamic IN clause within a PL/SQL block when the list of values for the IN clause is provided with a string or a table column ? I have seen, on the ORAQA a post that explains...
I have just seen a recent Laurent Schneider's blog entry about selecting from a LONG column http://laurentschneider.blogspot.com/2006/01/select-from-test-where-mylong-like.html. Then i remember another question on this same forum where the guy need to...
This site is a kind of “superstore” where people from the Oracle Forms Community can share their knowledge and provide their own solutions. If you are looking for PJC & Javabean solutions for your Oracle Forms applications, or if you want to share your...
JInitiator uses the JRE 1.3 version. This excludes the use of all the new Java features available in the next versions of the JRE. This is the reason why, it is a good think to stop using JInitiator and replace it with the Sun Java Plugin. Here is a short...
It is a good idea, in an Oracle Forms application, to put a particular color on items when the user toggle to the Enter-Query mode. Here are 2 PL/SQL generic procedures you can put into your own PL/SQL library to do the job. You only need to create two...
I notice sometimes questions about how to handle CLOB columns in a Forms 6i / 9i application. It seems to be very difficult to use CLOB variables within Forms to handle correctly the whole datum. For the purpose of creating a file on disk with the content...
I Often see threads on forums about how to apply massive changes to a large number of forms. One solution is to use the JDAPI tool provided by Oracle (download the JDAPI Documentation). It is a Java tool that allows to open the .FMB files, add/modify/remove...
I have received requests from people who do not want to install the full "Summit" Oracle Forms application to test the Look and Feel tool, or simply have still the old 9i version.I have upgraded the current version zip file that contains both test_laf_10gr2.fmb...
One of my recent assignments was to build a web page that needed to show images that are stored in a database. Having a strong PLSQL coding background the solution seemed to be close to my fingertips and I created a PLSQL function that I called through...
In the Forms OTN forum, Rosario Vigilante explains how to be sure Forms will use the desired Java plugin at runtime. For those that want to keep the Forms running with an old plugin (1.4 for instance) even if a newer version is alread installed on the...
Here is a code snippet showing how you can test if a file exists on a web site (that you have access, of course). It uses the UTL_HTTP database package. DECLARE url VARCHAR2(256) := 'http://sheikyerbouti.developpez.com/tmp/f6_menus/menudef.mmb'; username...
Hello there, I would be pleased to present the brilliant work of a nice French person, who has developped a library, capable of encapsulating the so complex OCI interface. It is a powerful workaround for those C programmers that are not totally satisfied...