ORACLE ¹ý³ÌÖÐÈÝ´í´¦Àí

  1) »ù±¾½á¹¹
  BEGIN
    ... --Óï¾ä
  EXCEPTION -- ÀýÍâ´¦Àí
    WHEN ...
    ...
    WHEN OTHERS
      ...
  END;
  2) ³£ÓÃÔ¤¶¨ÒåÀýÍâ
  EXCEPTION
    WHEN CURSOR_ALREADY_OPEN THEN -- ORA-06511 SQLCODE = -6511 ÓαêÒѾ­´ò¿ª
      ...
    WHEN DUP_VAL_ON_INDEX THEN -- ORA-00001 SQLCODE = -1 ÏòΨһË÷ÒýÖвåÈëÖظ´Êý¾Ý
      ...
    WHEN INVALID_CURSOR THEN -- ORA-01001 SQLCODE = -1001 ·Ç·¨Óαê²Ù×÷
      ...
    WHEN INVALID_NUMBER THEN -- ORA-01722 SQLCODE = -1722 ×Ö·ûÏòÊý×Öת»»Ê§°Ü
      ...
    WHEN LOGIN_DENIED THEN -- ORA-01017 SQLCODE = -1017
      ...
    WHEN NO_DATA_FOUND THEN -- ORA-01403 SQLCODE = +100 ûÓÐÕÒµ½Êý¾Ý
      ...
    WHEN NOT_LOGGED_ON THEN -- ORA-01012 SQLCODE = -1012
      ...
    WHEN PROGRAM_ERROR THEN -- ORA-06501 SQLCODE = -6501 ³ÌÐò´íÎó
      ...
    WHEN STORAGE_ERROR THEN -- ORA-06500 SQLCODE = -6500
      ...
    WHEN TIMEOUT_ON_RESOURCE THEN -- ORA-00051 SQLCODE = -51
      ...
    WHEN TOO_MANY_ROWS THEN -- ORA-01422 SQLCODE = -1422 ·µ»Ø¶àÐÐ
      ...
    WHEN TRANSACTION_BACKED_OUT THEN -- ORA-00061 SQLCODE = -61
      ...
    WHEN VALUE_ERROR THEN -- ORA-06502 SQLCODE = -6502 Êýֵת»»´íÎó
      ...
    WHEN ZERO_DIVIDE THEN -- ORA-01476 SQLCODE = -1476 ±»Áã³ý
      ...
    WHEN OTHERS THEN -- ÆäËüÈκδíÎóµÄ´¦Àí
&nb