Articles Oracle Forms, PL/SQL, Java, J2EE
When you migrate to the latest Forms version (10.1.2.3 or 11) and try using a JavaBean created with an older Forms version, you can get the following error, at runtime, in the Java Console: Exception in thread "thread applet-oracle.forms.engine.Main-1"...
The American Oracle Development Tool User Group organizes a special event entirely reserved to the Oracle Forms product. Yes, you read right, a 100% Forms event ! Two days to learn a lot about Forms: Templates WebUtil Using HTML and JavaScript Introduction...
When you deliver an application, the job is not really complete if it is not shipped with a help system. Sometimes, for small projects, the budget allowed does not take into account the help system. (talking about buying a tiers robot help maker solution...
In the next version of the LAF - 1.4 - I will introduce a Scrolling Panel able to scroll any HTML content. You woul be able to have a sort of scrolling banner in your Forms application, usefull when you have a lot of information to display in a small...
Here are links to the Oracle Forms 10g Services documentation for those who are looking for some tuning information: Oracle® Application Server Forms Services Deployment Guide10g Release 2 (10.1.2) http://download-uk.oracle.com/docs/cd/B25016_04/doc/dl/web/B14032_03/toc.htm...
The Aerith Java swing demo source code is available "...Aerith is a demo we (Richard Bair, Joshua Marinacci, Chet Haase, Chris Campbell and I) wrote at Sun Microsystems for JavaOne. The featured application is a trip report editor and Flickr account viewer....
The new Forms Look and Feel Project 1.6.1 version is out. It is just a (very) minor version that corrects a few bugs and add little enhancements: Enhancement on Robot feature You can, now, have Bubbles with HTML content Bubble text can contains commas...
How to encrypt/decrypt strings with the dbms_obfuscation_toolkit / dbms_crypto packages Oracle 9i dbms_obfuscation_toolkit package CREATE OR REPLACE PACKAGE Cryptit AS FUNCTION encrypt( Str VARCHAR2 ) RETURN RAW; FUNCTION decrypt( xCrypt VARCHAR2 ) RETURN...
The DBMS_PROFILER package allows to determine the time taken by each instruction of your code. At the same time, you could also see the internal processing time for the basic instructions. Of course, these times depend on the power of the test machine....
Because I like anything which is "dynamic", I have played with the DBMS_SQL package. My goal was to send any Select order to a procedure and get a collection of records and a datastructure to manipulate these records. So, this is the trick: CREATE OR...
Someone (his/her name is Torben) put a comment on my last java Bean article about how to transform a Forms application into a socket server. He decided to use the bean to send message from the database: DECLARE c utl_tcp.connection; -- TCP/IP connection...
Since the 10g version, when you drop a table, you could see another table in the USER/ALL/DBA_TABLES views. The name of this new table looks a little bit funny, like : BIN$B9405sOZRq2GkbE/z5Gwaw==$0 What is this ? This is the new RECYCLEBIN feature that...
For a checking out purpose, I would be able to display the HTML content of a Text Item in the default Internet Browser window. My first thought was to create a HTML file on the local machine then call it with the Webutil functions: client_text_io() functions...
The new Forms Look and Feel Project 1.6.2 version is out. It is just a (very) minor version that corrects a few bugs and add little enhancements: Enhancement on LAF LOVs You can set some width properties on every column: . Default Width . Minimum Width...
The forms-pjc-bean site is a library for Oracle Forms Javabeans and PJCs . The relation with the Oracle company starts and ends here. This material, these articles do not come from Oracle, have nothing to do with Oracle and are certainly not taken into...
Sometimes, I receive mails from LAF (future) users to ask me if the tool can do this or that. I realized that, actually, there is nothing that describes, in a single document, all the functions that are part of the LAF tool. So, I created a new page,...
Here is the Top 10 of the PJCs/JavaBeans you have prefered in September 2007: The Forms Look and Feel project 409 A Java Bean to print files to the local printer 244 Forms and Images : keep the initial quality 240 A Full Web Browser Java Bean 210 A Dynamic...
It is frequently asked how to load a BLOB table column from the content of an external file. This can be achieved by using the DBMS_LOB package's functions. Sometimes it is also useful to extract the BLOB content back to a file. Here is a procedure that...
Andreas Weiden has just created a nice Java Bean to highlight the status bar in the aim of drawing the end-user attention on the new incoming message. The status bar's background is colored, a few seconds, with a shadow effect, so that the user cannot...
Sometimes, I see some posts on forums about Oracle Forms "downgrading" possibilities.Questions like: I have lost the source modules (*.??B), can I retrofit from the executable modules (*.??X) ?The answer is: NO I have just migrated from Forms 9i to Forms...
Using a good old Forms application on a brand new mobile? Are you kidding? Mia Urman and Oraplayer will be presenting the full process in detail in a FREE webinar hosted by ODTUG called Take Your Oracle Forms on the Road Using ADF Mobile “In our constant...
Wilfred van der Deijl has just published a white paper about how to integrate Oracle Forms in a web application.This is the most important concept I have ever seen about the Oracle Forms technology.Have a look, if you have both Forms and J2EE applications,...
I was asked to build a JSP page within our Portal application to show some employee's characteristics.It is easy to get all the common attributes with the search() method, but I never found anything to get the photo. Maybe this kind of function exists...
It seems that many people would like to apply massive changes within their existing Forms applications, but do not have the skill (or the time) to deal with the Oracle JDAPI stuff. I have started a project targeting to do this kind of massive changes...
This is a simple PL/SQL package that allows to insert, update and check existence of users in the LDAP. The package Specification CREATE OR REPLACE PACKAGE Pkg_Ldap IS /* * Package to handle the LDAP From PL/SQL * All functions use the DBMS_LDAP package...
