PL/SQL_預存程序樣本

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所用參數