Function Render_Region (p_region In apex_plugin.t_region
                            ,p_plugin In apex_plugin.t_plugin
                            ,p_is_printer_friendly In Boolean 
) Return apex_plugin.t_region_render_result Is
  l_result apex_plugin.t_region_render_result;

Begin
sys.htp.p('<output type="text" id="P_TEXT"><label for="1">Выберите штат отправления:  </label>');
sys.htp.p('<select id="P_SL" size="1" >');
 for i in (select ST return_value, STATE_NAME display_value
           from DEMO_STATES)
  LOOP
        apex_plugin_util.print_option (
        p_display_value => i.display_value,
        p_return_value  => i.return_value,
        p_is_selected   => apex_plugin_util.is_equal(i.return_value,1),
        p_attributes    => null,
        p_escape        => false );
  END LOOP;
sys.htp.p('</select><Br>');


sys.htp.p('<output type="text">
<label for="1">Выберите штат назначения:  &nbsp  </label>');
sys.htp.p('<select id=null name="state2" size="1" >');
 for i in (select ST return_value, STATE_NAME display_value
           from DEMO_STATES)
  LOOP
        apex_plugin_util.print_option (
        p_display_value => i.display_value,
        p_return_value  => i.return_value,
        p_is_selected   => apex_plugin_util.is_equal(i.return_value,1),
        p_attributes    => null,
        p_escape        => false );
  END LOOP;
sys.htp.p('</select><Br>');


sys.htp.p('<INPUT TYPE="submit" id="SaveButton" VALUE="Сохранить" onClick="javascript: alert('||''' done! '''||');">');
  return l_result;
End Render_Region;

document.getElementById('P_SL').options[document.getElementById('P_SL').selectedIndex].value;

begin
INSERT INTO test1(otpr,nazn) VALUES(:P26_X,'2'); 
end;