Francois Degrelle's blog

Send message to Forms from the database

Oracle Forms

Par Francois Degrelle

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

Lire la suite

PJC & Java Bean store : a tree menu to search

Oracle Forms

Par Francois Degrelle

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

Lire la suite

Oracle Forms : count detail of DML operations

Oracle Forms

Par Francois Degrelle

Here is a workaround that allows to count rows impacted by DML operations in each based block of a form. It consists in three form-level triggers and one program unit. The program unit: PROCEDURE Dml_rowcount ( PC$Mode In Varchar2 ) IS LC$Var Varchar2(100)...

Lire la suite

New Ajax Forum (French)

J2EE

Par Francois Degrelle

The French developer forum that I contribute within the Oracle section has just opened a new Ajax Forum (French speaker only)

Lire la suite

Send messages to a Forms application from the outside ? yes you can !

Oracle Forms

Par Francois Degrelle

Here is a Java bean that allows to transform a Forms module into a socket server. This way, it can receive messages from the outside. In this example, the messages are sent through a telnet session. Read the article

Lire la suite

Forms 10gR2 new internal pl/sql encoding

Oracle Forms

Par Francois Degrelle

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

Lire la suite

Forms LOV : avoid the user to select twice the same value

Oracle Forms

Par Francois Degrelle

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

Lire la suite

Forms PJC : set the Text item cursor from any image

Oracle Forms

Par Francois Degrelle

Here is a PJC that allows to set a Text item cursor from any image stored in the jar file. Read the article

Lire la suite

Forms 10g and Java Plugin

Oracle Forms

Par Francois Degrelle

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

Lire la suite

Forms, regular expressions and Java Plug-in

Oracle Forms

Par Francois Degrelle

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

Lire la suite