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

 &n