1>Pl/sql中写过程,编辑.
create or replace procedure PRO_****(
p_**** in varchar2,
p_**** in varchar2,
p_**** out varchar2) is
/*declare*/
p_**** varchar2(20) := p_**** ;
p_**** varchar2(20);
p_**** varchar2(10);
begin
while p_subject <> '-1' loop
select count(*)
into p_count
from cw.****
where **** = ****;
if p_count = '0' then
INSERT INTO cw.****
else
UPDATE cw.**** SET
end if;
**** := p_****;
end loop;
update CW.****
set **** = **** || '.' || rownum
where **** = ****
commit;
exception
when others then
raise_application_error(-20002,
'PRO_ID_SCATTER_SUM, 原因:' || SQLCODE || ', ' ||
SQLERRM || p_out_result);
end;
2>.java Service
map.put("p_****", map.get("****")+"");
map.put("p_****", map.get("****")+"");
map.put("p_****", map.get("****")+"");
dao.update("****.PRO_****", map);
3>.xml 中设置好参数 IN OUT
<parameterMap id="PRO_****" class="map" >
<parameter property="p_****" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="p_****" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="p_****" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT"/>
</parameterMap>
<procedure id="PRO_****" parameterMap="PRO_****" >
<![CDATA[
{ call PRO_****(
? ,
? ,
?
)}
]]>
</procedure>
4>进行操作,验证正误 end...
类中put所用参数