Oracle Forms Community - Pluggable Java Components & Java Beans' library

Purpose

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

     oracle.forms.gp.FileDropBean

The event fired by the Java Bean


 DROP


The full filemane is transmitted in the EVENT_MSG parameter.

DECLARE
 l_eventName varchar2(30) := :system.custom_item_event;
 l_eventValues ParamList;
 l_eventValueType number;
 l_event_msg VARCHAR2(255);
BEGIN
   IF l_eventName = 'DROP'
   THEN
      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'
      THEN
         create_record;
      END IF;
      :ctrl.file_location := l_event_msg;
   END IF;
END;