当我调用此过程时,返回映射无法获取输出参数
操作步骤为:
create or replace procedure myDemo05(name out varchar,age in int)
as
begin
dbms_output.put_line('age='||age);
insert into students values(age,age,age+'');
select 'xiaoming' into name from dual;
end;mapper.xml为:
<select id="updateRet2" parameterType="java.util.LinkedHashMap" resultType="java.util.LinkedHashMap" statementType="CALLABLE">
{
call ${spName}
<foreach collection="datas" index="key" item="ent" open="(" separator="," close=")">
<if test="ent == '?'">
#{ent,mode=OUT,jdbcType=VARCHAR}
</if>
<if test="ent != '?'">
#{ent,mode=IN,jdbcType=INTEGER}
</if>
</foreach>
}
</select>过程OUT参数不能返回!
发布于 2020-10-29 15:29:27
我调试了它,发现:,但它不能把"_frch_ent_0“的paramMap…

发布于 2020-10-29 16:03:55

mapper.xml应该这样写!
https://stackoverflow.com/questions/64586102
复制相似问题