try {
    StoredProcedureQuery storedProcedureQuery
            = em.createStoredProcedureQuery("XXXX", Test.class);
    storedProcedureQuery.execute();
    return storedProcedureQuery.getResultList();
} catch (Exception e) {
    e.printStacktrace();
} finally {
    em.close();
}