PROSAGA码农传奇-plsql-从Spring Boot调用Oracle PL / SQL函数时出错

<div class =“post-text”itemprop =“text”>
  
    最后，这个SO链接（
    <a href="https://stackoverflow.com/questions/14335939/how-to-call-oracle-function-or-procedure-using-hibernate-entitymanager-or-jpa/14722588">
      如何使用Hibernate（EntityManager）或JPA 2调用Oracle函数或过程
    </A>
    ）和这篇文章（
    <a href="https://vladmihalcea.com/how-to-call-oracle-stored-procedures-and-functions-from-hibernate/" rel="nofollow noreferrer">
      https://vladmihalcea.com/how-to-call-oracle-stored-procedures-and-functions-from-hibernate/
    </A>
    帮助我解决了我的问题。我做的改变让事情变得有效。
  
  
    的
      LinkAppl.java
    </强>
  
   <pre>
 <code>
 @Entity
@Table(name = "LINK_APPL")
public class LinkAppl {
 private String applId;
 private String applDeTx;
 private String seqNbResetCd;
 private String intfMsgFrmtCd;
 private String sndRcvCd;
 private String applAcptMsgFrmtCd;
 private String applActvCd;
 private String sodEodIn;
 private String linkNotesTx;
 private String lastModByUsrId;
 private Timestamp lastModTs;
 private String sndCnctStsCd;
 private Long maxSeqNb;
 private String batIntfIn;
 private String gfpSrcSiteCd;
 private String rcvRterAckmentIn;
 private String rcvMqCodIn;
 private String fxApplIn;
 private String rcvEodpAckmentIn;
}

</code>
 </pre>
  
    的
      LinkApplService.java
    </强>
  
   <pre>
 <code>
 @Service
@Log4j2
public class LinkApplService {

private static final String CHECK_ACTIVE_APPL_QUERY = "select PKG_USROUTER.CHECK_ACTIVE_APPL(:appl) from DUAL";

@PersistenceContext
    private EntityManager em;
    @Autowired
    private LinkApplRepository linkApplRepository;

public String checkApplicationActive(String applicationId) {
        String activeFlag = (String) em.createNativeQuery(CHECK_ACTIVE_APPL_QUERY)
                .setParameter("appl", applicationId)
                .getSingleResult();
        log.debug("activeFlag: " + activeFlag);
        return activeFlag;
    }

}

</code>
 </pre>
  
    的
      LinkApplController.java
    </强>
  
   <pre>
 <code>
 @Controller
@RequestMapping("/applications")
@Log4j2
public class LinkApplController {

@Autowired
    private LinkApplService linkApplService;

@GetMapping
    public String getAllApplLinks(Model model) {
        String activeFlag = linkApplService.checkApplicationActive("TITAN");
        log.debug("@@@@@@@@@@@@@@@@activeFlag: " + activeFlag);
        model.addAttribute("activeFlag", activeFlag);    
        return "index";
    }
}

</code>
 </pre>
</DIV>