Call Stored Procedure

`

<a class="mention" href="/u/override">@Override</a>

@Transactional(propagation = Propagation.REQUIRES_NEW)

public String executaProcedureConfirmacao(Long codigoEc, Long operNumOperacaoSeq, String userOperacao, Long codCanal, Double valorOperacao) {

Session session = getEntityManager().unwrap(Session.class);

SessionFactoryImpl sessionFactory = (SessionFactoryImpl) session.getSessionFactory();

ConnectionProvider cp = sessionFactory.getConnectionProvider();

Connection connection = null;

String sucesso = “”;

try {

connection = cp.getConnection();

		CallableStatement cs = connection.prepareCall("{call PK_STATUS.PR_CONFIRMA_SIMULACAO(?,?,?,?,?,?) }");
		cs.registerOutParameter(6, OracleTypes.NVARCHAR);
		cs.setLong(1, codigoEc);
		cs.setLong(2, operNumOperacaoSeq);
		cs.setString(3, userOperacao);
		cs.setLong(4, codCanal);
		setNumberOrNull(5, valorOperacao, cs);
		cs.execute();
		sucesso = cs.getString(6);
	} catch (SQLException e) {
		e.printStackTrace();
	}

	return sucesso;
}