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;