返回顶部

收藏

oracle 自定义异常

更多
SQL>
SQL>
SQL> -- User defined exception
SQL>
SQL>  begin
  2      declare --start of nested block
  3        NESTED_EXCEPTION exception;
  4      begin
  5        raise NESTED_EXCEPTION;
  6      end; --end of nested block
  7    exception
  8      when NESTED_EXCEPTION then
  9        dbms_output.put_line('NESTED_EXCEPTION caught!');
 10    end;
 11    /
    when NESTED_EXCEPTION then
         *
ERROR at line 8:
ORA-06550: line 8, column 10:
PLS-00201: identifier 'NESTED_EXCEPTION' must be declared
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated

SQL>
SQL>

标签:Oracle,SQL

收藏

0人收藏

支持

0

反对

0

发表评论