Overblog Suivre ce blog
Editer l'article Administration Créer mon blog
27 août 2011 6 27 /08 /août /2011 07:56


Here is a Java Bean from Gert Poel, to Drop an external file within the Forms applications.

The Java source

     FileDrop.java   FileDropBean.java

The implementation class of the Java Bean


The event fired by the Java Bean


The full filemane is transmitted in the EVENT_MSG parameter.

 l_eventName varchar2(30) := :system.custom_item_event;
 l_eventValues ParamList;
 l_eventValueType number;
 l_event_msg VARCHAR2(255);
   IF l_eventName = 'DROP'
      l_eventValues := get_parameter_list(:system.custom_item_event_parameters);
      get_parameter_attr(l_eventValues,'EVENT_MSG',l_eventValueType, l_event_msg);
      IF :system.record_status <> 'NEW'
      END IF;
      :ctrl.file_location := l_event_msg;
   END IF;

The sample dialog

Download the filedrop.zip file
     . Unzip the filedrop.zip file
     . Copy the FileDrop.jar file in your /forms/java/ folder
     . Add it to the archive and archive_jini tags of the /forms/server/formsweb.cfg file
     . Open the FILEDROP.fmb module (Oracle Forms 10.1.2)
     . Compile all and run the module

Partager cet article

Repost 0
Published by Oracle Forms community - dans Bean - general
commenter cet article


Angelos 22/08/2017 15:14

Hi there,

I know this is an old post, but I was hoping you might be able to help with something.
I was using the bean with forms 11g. After an upgrade to 12c the bean no longer works. The drop square seems completely inactive and nothing happens.
Do you perhaps have any ideas?

Thank you!

Francois 25/08/2017 09:14

Sorry, but it is a long time I stopped working whith that... I ha no idea. Display the Java console at runtime. Maybe it is related to new Java Applet policies...

Henry 21/04/2016 04:03


I can't run in administrator mode, is there any restrictions or suggestions?

Thanks in advance!

Alexandra GAUTHIER 13/02/2013 17:35


I was really interested by your Java Bean ... but I have this error message, could you help me ?

error java.lang.UnsupportedClassVersion ....



Oracle Forms community 14/02/2013 05:11

This means that the Bean was compiled with a more recent version than the JRE you use to run Form. Maybe you're still using the old JInitiator. Upgrade to a more recent JRE.

Philippe 21/11/2012 15:25

Hi Geert,


I'm having trouble with the filedropper: the demo fmb is ok but when I enhance it to have a base tabled block to store Blobs using webutil it freezes the application and the file explorer (during
the communication with the bean in th WCIE).  Can you help me ?

Oracle Forms community 21/11/2012 15:41

Gert has no access to my blog, so I suggest you to ask that question on the Forms.PJC.Bean forum.
Choose one of the first two sub-forums (PJC or JavaBean)  ;-)


Stephan van Hoof 08/10/2012 16:18


Regarding the FileDropBean:

Am I right to conclude that only the file-name is send from applet to the Forms runtime (connected and running frmweb.exe) on server?

In other words: no bytes are transfered to the server?

Thanks, regards, Stephan



Oracle Forms community 08/10/2012 23:26

Yes, you are right.