Oracle,SqlServer,DB2存储过程中异常处理

1.Oracle中的异常处理:

   exception
    when others then

       异常的处理

    end

   例如：   

 create or replace procedure sp_query_test(p_id in int,

                                                   p_errorcode in out int,
                                                   p_errormsg  in out varchar2)

 is

  p_sql varchar(3000);

 begin

   p_errorcode:=0;

   p_errormsg :='ok';

   p_sql:='insert into test (id,iname,icode,iaddr) select name,code,addr from test2 whe