pl/sql非预定义异常之ORA-02292小例子

最新推荐文章于 2025-05-07 18:43:26 发布

最新推荐文章于 2025-05-07 18:43:26 发布 · 204 阅读

本文介绍了一种在Oracle数据库中尝试删除部门记录时遇到ORA-02292错误的情况，并通过PL/SQL块成功捕获并处理了该异常。文章展示了如何定义异常、与错误号关联以及使用dbms_output显示错误信息。

delete from dept where deptno = 10;
delete from dept where deptno = 10
*
ERROR at line 1:
ORA-02292: integrity constraint (SCOTT.FK_DEPTNO) violated - child record found
SQL> declare
  2    e_deptid exception;       --定义异常
  3    pragma exception_init(e_deptid,-2292);       --将异常和错误号关联
  4  begin
  5    delete from dept where deptno = 10;
  6  exception
  7    when e_deptid then         --捕获异常
  8      dbms_output.put_line('There is record at sub table');
  9  end;
 10  /
There is record at sub table
PL/SQL procedure successfully completed.