jsp调用存储过程实例.txt

jsp编码：
定义CallableStatement proc=null;


sql="{call pc_ch_cd_01(?,?,?,?)}";   
proc=conn.prepareCall(sql);     
proc.setString(1,zd14_jtxzq);  
proc.setString(2,result0);  
proc.setString(3,csdy_yzbm);  
proc.registerOutParameter(4,Types.VARCHAR);  
proc.execute();              
String jtjd_code=tb.ntos(proc.getString(4));
proc.close();

存储过程：
create or replace procedure pc_ch_cd_01(area_code_in in varchar2,
                                        name_in      in varchar2,
                                        yzbm_in      in varchar2,
                                        code_out     out varchar2) is
  bmws_tmp    number;
  name_tmp    varchar2(100);
  code_tmp    varchar2(10);
begin
  name_tmp:=name_in;
  select bmws into bmws_tmp from cs_bmxxfa where code = '08' and bmjb = 2;
  name_tmp:=fc_ch_cdmp_filter(area_code_in,name_tmp);
  begin
    select code into code_out from ch_cd where fullname = name_tmp and rownum=1;
  exception
    when NO_DATA_FOUND then