Николай Бараненко

Calendar fDATETIME = Calendar.getInstance(); // creates calendar
        Calendar tDATETIME = Calendar.getInstance();
        SimpleDateFormat ShortDateFormat = new SimpleDateFormat("dd.MM.yyyy HH:mm:ss");
        SimpleDateFormat DateFormatForSQLOracle = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

        fDATETIME.setTime(ShortDateFormat.parse(DATETIME_FROM));
        tDATETIME.setTime(ShortDateFormat.parse(DATETIME_TO));

        try (Connection conn = DriverManager.getConnection(DB_URL_Connection, DB_UserName, DB_Password)) {
            PreparedStatement prepStmt = conn.prepareStatement(sql);
            prepStmt.setTimestamp(1, java.sql.Timestamp.valueOf(DateFormatForSQLOracle.format(fDATETIME.getTime())));
            prepStmt.setTimestamp(2, java.sql.Timestamp.valueOf(DateFormatForSQLOracle.format(tDATETIME.getTime())));
            prepStmt.setString(3, "%Хост: %");

            ResultSet result = prepStmt.executeQuery();

declare
  l_statement varchar2(32767);
begin

  l_statement := 'begin
                     EXAMPLE1_POINTS(''Да'',''средний"'');
                  end;';
  begin
     execute immediate l_statement;
  exception
     when others 
     then 
       null;
        /*log_error(sqlerrm);*/
  end;


  l_statement := 'begin
                     EXAMPLE2_POINTS(''Да'',''средний"'');
                  end;';
  begin
     execute immediate l_statement;
  exception
     when others 
     then 
       null;
        /*log_error(sqlerrm);*/
  end;

  l_statement := 'begin
                     EXAMPLE3_POINTS(''Да'',''старый"'');
                  end;';
  begin
     execute immediate l_statement;
  exception
     when others 
     then 
       null;
        /*log_error(sqlerrm);*/
  end;

end;