//----------------------------------------------------------------------------------------------------------------//
    public static void callOracleStoredProc(String fileName, String typeData) {

        Connection dbConnection = null;
        String StoredProc = null;
        CallableStatement callableStatement = null;
        String charset = null;

        try {

            if (typeData == "KIS") {
                StoredProc = "{call load_cust_kis(?,?,?)}";
                charset = "CP1251";
            }
            else if (typeData == "PEP") {
                StoredProc = "{call load_cust_pep(?,?,?)}";
                charset = "UTF8";
            } else {
                log.error("No find type data in private static void callOracleStoredProc");
                System.exit(1);
            }

            log.info("set stored procedure " + StoredProc);
            log.info("set charset from file " + charset.toString());

            dbConnection = getDBConnection();
            File file = new File(fileName);

            log.info("read data from file " + fileName);
            FileInputStream is = new FileInputStream(file);
            InputStreamReader isr = new InputStreamReader(is, charset);

            callableStatement = dbConnection.prepareCall(StoredProc);

            callableStatement.setString(1, file.getName());
            callableStatement.setClob(2,isr);
            callableStatement.registerOutParameter(3, java.sql.Types.CLOB);
            log.info("processing the uploaded data on the url:  " + dbConnection.getMetaData().getURL());
            callableStatement.execute();
            log.info("processing result : " + callableStatement.getString(3));

        } catch (SQLException e) {
            log.error(e.getMessage());
        } catch (FileNotFoundException e) {
            log.error(e.getMessage());
        } catch (IOException e) {
            log.error(e.getMessage());
        } finally {
            try {
                if (callableStatement != null) {
                    callableStatement.close();
                }
                if (dbConnection != null) {
                    dbConnection.close();
                }
            } catch (SQLException e) {
                log.error(e.getMessage());
            }
        }

    }

log.info("read data from file " + fileName + ", size (byte): " + file.length());

[INFO ] 2016-10-28 18:00:18.358 [main] Upload:156 - read data from file .//downloads/161028_1513_pep.xml, size (byte): 24044889