StoredProcedureQuery call2 = em.createStoredProcedureQuery( "testproc2" );
call2.registerStoredProcedureParameter( 0,Integer.class, ParameterMode.IN );
call2.setParameter( 0, 1 );
Integer singleResult = (Integer) call2.getSingleResult();

StoredProcedureQuery call3 = em.createStoredProcedureQuery( "testproc3",Car.class );
call3.registerStoredProcedureParameter( 0,Void.class, ParameterMode.REF_CURSOR );
call3.registerStoredProcedureParameter( 1, String.class, ParameterMode.IN );
call3.registerStoredProcedureParameter( 2, String.class, ParameterMode.IN );
call3.setParameter( 1, "id" );
call3.setParameter( 2, "title" );
List<Car> listResult = call3.getResultList();

StoredProcedureQuery call3 = em.createNamedStoredProcedureQuery( "testproc4_1" );
call3.setParameter( 1, "id" );
call3.setParameter( 2, "title" );
List<Car> listResult = call3.getResultList();