pl/sql之异常小例子

-- Created on 2014/3/11 by EX_ZHANGKENAN
declare
-- Local variables here
a VARCHAR2(50);
begin
-- Test statements here
SELECT user_name INTO a FROM t_user --WHERE user_id LIKE '%2%' ;
DBMS_OUTPUT.put_line('aaaa');
EXCEPTION
WHEN no_data_found THEN
SELECT T11_SEQ.NEXTVAL INTO a FROM dual;
DBMS_OUTPUT.put_line('no_data_found');
DBMS_OUTPUT.put_line('bbbbb');
DBMS_OUTPUT.put_line('no_data_found');
WHEN too_many_rows THEN
DBMS_OUTPUT.put_line('too_many_rows');
DBMS_OUTPUT.put_line('ccccc');
DBMS_OUTPUT.put_line('too_many_rows');
WHEN OTHERS THEN
DBMS_OUTPUT.put_line('otheres');
DBMS_OUTPUT.put_line('ddddd');
DBMS_OUTPUT.put_line('otheres');
end;