Francois Degrelle's blog

PL/SQL : a procedure to output content of BLOB columns onto the file system

Oracle PL-SQL

Par Francois Degrelle

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...

Lire la suite

Jonathan Lewis session in Paris : Report (French)

Other

Par Francois Degrelle

Jonathan Lewis has given a two day session in Paris last 10 and 11 September about Cost Based Optimisation. Read the short report of the event (in French)

Lire la suite

Forms : A JavaBean to handle CLOB/NCLOB columns

Oracle Forms

Par Francois Degrelle

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...

Lire la suite

Forms JavaBean : access to the Window menu

Oracle Forms

Par Francois Degrelle

Here is a Java Bean to read the Window Forms menu option. You have access to every window opened in the Forms application to minimize or restore them. Read the article

Lire la suite

Forms JavaBean : The return of the Keep the Initial Image Quality

Oracle Forms

Par Francois Degrelle

Here is a Java Bean that allows reading, displaying with scaling and writing images. This bean is a more elaborated image handler (than this one). It allows scaling images to fit the target item size, and includes a FileChooser with image preview dialog....

Lire la suite

Oracle Forms : how to enforce using the desired Java plugin version

Oracle Forms

Par Francois Degrelle

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...

Lire la suite

Forms and Dynamic SQL (EXEC_SQL)

Oracle Forms

Par Francois Degrelle

I frequently see questions on Forums about how to handle a cursor with a dynamic Where clause. Oracle Forms has a special package named : EXEC_SQL that allows using dynamic SQL in the Forms application. Here is a sample dialog that queries the EMP table...

Lire la suite

JDeveloper : a Media Library

J2EE

Par Francois Degrelle

Tristan Fabre has just finished a tutorial about how to build a media library with JDeveloper and ADF. Someone interested in?

Lire la suite

August 9, 2007 as "Frank ZAPPA DAY" in Baltimore...

Other

Par Francois Degrelle

NOW, THEREFORE, I, SHEILA DIXON, MAYOR OF THE CITY OF BALTIMORE, do hereby proclaim August 9, 2007 as "Frank ZAPPA DAY" in Baltimore and do urge all citizens to join inthis celabration. Frank Zappa had still a statue in Republic Tcheque, a street in Berlin...

Lire la suite

2 days to learn a max about Oracle Forms!

Oracle Forms

Par Francois Degrelle

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...

Lire la suite