Articles Oracle Forms, PL/SQL, Java, J2EE
This PJC is a workaround to the issue defined in the bug 3867157 on Metalink. It allows having the same behaviour on the Web that the one it has on the C/S version. The When-List-Changed trigger would fire only when the mouse is clicked or when the Enter...
My partner has been recently hired in Parma (Italy). So that I spent the last week-end with her, in her new apartment downtown. It is not the first time I spend time in Italy, and I continue to be attracted by this nice country. In Parma, People are kind,...
Here is a few links to point to some Forms books (Amazon): Oracle Developer Forms Techniques (Paperback) Oracle Forms Developer -- The Complete Video Course Oracle Forms Interactive Workbook (Interactive Workbook Series) (Paperback) Programming with Oracle...
Hello, I received, today, a request from a person who wanted to display HTML text stored in a database column in his Forms application. I suggested to use the HTML pane Java Bean, but he claimed that his HTML text contains hyperlinks, so I thought about...
Hello every Forms Look and Feel users ! I'm working on a new site to host the Look and Feel project, and I would be interested in showing a page containing screen-shots of applications using it. I know that you are a few people (4 or 5 tens) using it...
My small company did not survive the financial crisis. So now, I am looking for a new job. If you are looking for an Oracle ACE, Oracle Certified Professional, skilled in development tools like Designer, Forms, Reports, PS/SQL and with a good knowledge...
Recently, I was given an eletronic book about "Oracle 11g Streams Implementer's Guide" from Packt. See this book here. Through this book page the reader could also go through the sample chapter titled N-Way Replication. This would provide as the best...
For those who want to discuss about Oracle Forms PJCs and Java Beans integration, a new discussion forum has been created. It would be a better and more efficient way to share experience in real time with several people. If you are a Java Bean geek, develop...
Sometimes, when you add Java Beans/PJCs to your Oracle Forms application, you get Java memory error message, because your Java Bean needs big memory size, or just don't make some clean up. If you want to give more memory to the JVM, modify your /forms/server/xxbasexxx.htm...
Forms Magnifier is a tool that permits to display an Oracle Forms application exactly the same whatever the screen resolution is. Every component - Items but also Graphics - is moved/resized at runtime to fit the new screen size. Because I have developed...
This version has a new SET_WINDOW_PROPERTY() method added to the DrawLAF Java Bean to allow/prevent the user to do the following on the Forms window: move close maximize minimize resize disable show You can also change the MDI window state maximize state...
This new version comes with the JDBC asynchronous calls, that allow the developer to execute asynchronous database procedures and functions, via the JDBC driver, without "freezing" the Forms screen during the long time processes. Those executions are...
I receive sometimes requests by users that are interested by some features of the Forms Look and Feel tool, but don't want to install the whole stuff : .pll, .css, database packages, ... Even though you need the PLL and the CSS to easilly paint the canvases...
Tiny update of the LAF project. This 1.7.1.1 version sligtly improves the Image Spinner feature by consuming less memory. a new IMAGE_SPINNER_SET_KEEP_SIZE method can be used not to keep the original image size if you don't intend to save them later in...
For the LAf developers that want to have transparent with no border buttons, I see that some people try to use the FunButton PJC ( oracle.forms.fd.FunButton), that is not designed to do it. The FunButton has been created to render buttons that have a...
You would like to modernize your Forms applications, approach SOA, Webservices, Mobiles... At OraPlayer , they have the solutions. "Achieving SOA Without Migration Database – Refactor Forms Code to the DB Services – Running Webservices From Forms Client...
For those people who don't want to hear about anything else than PL/SQL, here is Web 2.0 framework that lets you build world class Web applications with only PL/SQL! Formspider apps run using 100% AJAX, DHTML and JavaScript without the need to know any...
For those who do not know, this is the OOW soon. And for those who also do not know, Forms is not dead, It is just only very aged, and a handful of people desperately try to make it exciting. Mia Urman is one of them, and she will talking on Tuesday,...
Merry Christmas to everybody :) This year, my present will be the Forms Resizer tool free for you! You can use, play, modify and deploy it as you need and as you want. There is no license at all attached to it. But, I won't continue to update, maintain...
Sometimes, we need, in an application, to extract some table rows to a flat file.This is a PL/SQL procedure that allows to extract the rows of a table, or the INSERT ordrers. You can download the script here Extraction_table procedure CREATE OR REPLACE...
It is not the first time I see this question on forums: "How can I restrict the values of my LOV, that the end user cannot select twice the same ?" One solution is to use a record group with a WHERE clause that excludes the records that has just been...
Sometimes, on forums, I see questions about dynamic SQL. This is one of them: "Hello, I would like to execute a function wich name is stored in a string. How could I do ?" The solution for this kind of problem is allways the dynamic SQL: Connected to:...
Since I am a very big fan of the music of Frank Zappa, i get everything i can fin about him. Here is some of his best quotations: Stupidity is the basic building block of the universe. There is no hell. There is only France. Don't mind your make-up, you'd...
A few weeks ago, I wrote an article about how to get data and data structure from a single Select order. At this time, I did not know what implementation I could do with this concept.Today, I know. This article shows how you can build a complete application...
It is not the first time I see, on forums, questions about how to restrict, at runtime, the number of characters a user can enter in a text item. The solution consists in understanding that every standard Forms widget has an associated PJC that can be...
