Samedi 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

Par Oracle Forms community - Publié dans : Bean - general
Send a comment - See the 3 comments
Retour à l'accueil
Créer un blog gratuit sur - Contact - C.G.U. - Rémunération en droits d'auteur - Signaler un abus - Articles les plus commentés