Suivre ce blog
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

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 file
     . Unzip the 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

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


Stephan van Hoof 08/10/2012


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



Philippe 21/11/2012

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 ?

Alexandra GAUTHIER 13/02/2013


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

error java.lang.UnsupportedClassVersion ....