StoredProcedureQuery storedProcedureQuery = em.createStoredProcedureQuery( TEST_RESULT_SET_STORED_PROC, "carMapping" );
storedProcedureQuery.registerStoredProcedureParameter( 0, Void.class, ParameterMode.REF_CURSOR );
storedProcedureQuery.registerStoredProcedureParameter( 1, Integer.class, ParameterMode.IN );
storedProcedureQuery.registerStoredProcedureParameter( 2, String.class, ParameterMode.IN );
storedProcedureQuery.setParameter( 1, 1 );
Parameter<String> p2 = storedProcedureQuery.getParameter( 2,String.class );
storedProcedureQuery.setParameter( p2, "title'1" );
@SuppressWarnings("unchecked")
List<Car> listResult = storedProcedureQuery.getResultList();
assertThat( listResult ).containsOnly( new Car( 1, "title'1" ) );