PL/SQL _ Stored Procedure example

1> write process in PL/SQL, Edit.

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, cause:' | 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> set the in out parameter in. xml

<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> perform the operation to verify that the end is incorrect...
Put parameters in the class