Named system exception in Oracle - Predefined PL/SQL Exceptions

前端之家收集整理的这篇文章主要介绍了Named system exception in Oracle - Predefined PL/SQL Exceptions前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

What is a named system exception in Oracle?

Named system exceptions are exceptions that have been given names by PL/sql. They are named in the STANDARD package in PL/sql and do not need to be defined by the programmer.

Oracle has a standard set of exceptions already named as follows:

Oracle Exception Name Oracle Error
DUP_VAL_ON_INDEX ORA-00001
TIMEOUT_ON_RESOURCE ORA-00051
TRANSACTION_BACKED_OUT ORA-00061
INVALID_CURSOR ORA-01001
NOT_LOGGED_ON ORA-01012
LOGIN_DENIED ORA-01017
NO_DATA_FOUND ORA-01403
TOO_MANY_ROWS ORA-01422
ZERO_DIVIDE ORA-01476
INVALID_NUMBER ORA-01722
STORAGE_ERROR ORA-06500
PROGRAM_ERROR ORA-06501
VALUE_ERROR ORA-06502
CURSOR_ALREADY_OPEN ORA-06511


Oracle PL/sql Exception:http://docs.oracle.com/cd/B10500_01/appdev.920/a96624/07_errs.htm

猜你在找的Oracle相关文章