Spring data jpa 调用存储过程

1,先保证升级相关的类库

<org.springframework-version>4.1.7.RELEASE</org.springframework-version>

<spring.data.jpa.version>1.9.6.RELEASE</spring.data.jpa.version>

<org.hibernate-version>5.0.8.Final</org.hibernate-version>

2，create stored procedure

PROCEDURE xxSearch_member(xPara in nvarchar2, xcur_ret out nvarchar2) is

  xkey1                 varchar2(100);
  xkey2                 varchar2(100);
  xname                 varchar2(100);
begin

    xkey1 := xxXml_child_text(xPara,'key1');
    xkey2 := xxXml_child_text(xPara,'key2');
    xName := xxXml_child_text(xPara,'name');
   
   xcur_ret :&#