plProcedure.append("declare ");
                        plProcedure.append("bresult BOOLEAN; ");
                        plProcedure.append("well DBMS_SQL.VARCHAR2_TABLE; ");
                        plProcedure.append("cmpd DBMS_SQL.VARCHAR2_TABLE; ");
                        plProcedure.append("batch DBMS_SQL.VARCHAR2_TABLE; ");
                        plProcedure.append("conc DBMS_SQL.NUMBER_TABLE; ");
                        plProcedure.append("qty DBMS_SQL.NUMBER_TABLE; ");
                        plProcedure.append("begin ");
             for (int r = 0; r < exelData.size(); r++) {
                            plProcedure.append("cmpd(" + r + ") := '" +
                                               exelData.get(r) +
                                               "'; ");
                        }
             for (int k = 0; k < batchNoList.size(); k++) {
                            plProcedure.append("batch(" + k + ") := '" +
                                               batchNoList.get(k) +
                                               "'; ");
                        }
             for (int p = 0; p < wellList.size(); p++) {
                            plProcedure.append("well(" + p + ") := '" +
                                               wellList.get(p) +
                                               "'; ");
                        }
                                                plProcedure.append(
                                "bresult := PACK_AB_IMPORT.INSERT_PLATE('");
                        plProcedure.append(barcodePasteData.get(i));
                        plProcedure.append("', '" + "NULL" + "', ");
                        plProcedure.append("'" + "NULL" + "', '");
                        plProcedure.append(plateFormatID);
                        plProcedure.append("','" + plateGroup + "', '");
                        plProcedure.append(assay +
                                           "', TO_DATE(' " +
                                           date + "','YYYY-MM-DD'), NULL, " +
                                           0 + ", ");
                        plProcedure.append("0, 0, '" + 0 +
                                           "', 0, 0, 0, NULL, ");
                        plProcedure.append("'" + "NULL" + "', '");
                        plProcedure.append("NULL" + "', '");
                        plProcedure.append("NULL" + "', NULL, ");
                        plProcedure.append("'" + resGroup + "', cmpd, ");
                        plProcedure.append("batch, well, qty, conc, '" +
                                           userName +
                                           "', TRUE, FALSE , NULL); end;");
                        System.out.println("PL PROCEDURE >>>>>>>." +
                                           plProcedure.toString());
                        System.err.println(plProcedure.toString());
                        stmtUploadPlate.execute(plProcedure.toString());