oracle 异常

 

 

plsql 异常

 

异常处理

EXCEPTION

 

WHEN ... THEN

WHEN ... THEN

WHEN OTHERS THEN ...

 

declare

 

begin

 

EXCEPTION

 

WHEN ... THEN

WHEN ... THEN

WHEN OTHERS THEN ..

end;

 

create type xtype as object(name varchar(20));

declare

   x xtype;

begin

   x.name:='aaa';

 

 exception

 when ACCESS_INTO_NULL then dbms_putput.put_line('init x first');

end;

 

declare 

  x number(9);

begin

  case 

    when x>200 then

       dbms_out.put_line('');

  end case;

 

exception

 when case_not_found then dbms_putput.put_line('init x first');

 

 

自定义异常

 

-----------own exception-------------

declare

 emp_notfound_exception exception;

begin

   update myemp set sal=sal+100 where empno=&empno;

   if sql%notfound 

       emp_notfound_exception;

   else

     dbms_output.put_line('ok');

   end if;

 

exception

  when emp_notfound_exception then

   dbms_output.put_line('not emp found');

 when others then

 

  null;

end;