大佬教程收集整理的这篇文章主要介绍了Named system exception in Oracle - Predefined PL/SQL Exceptions,大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。
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 | Explanation |
---|---|---|
DUP_VAL_ON_INDEX | ORA-00001 | You trIEd to execute an INSERT or UPDATE statement that has created a duplicate value in a fIEld restricted by a unique index. |
TIMEOUT_ON_RESOURCE | ORA-00051 | You were waiting for a resource and you timed out. |
TRANSACTION_BACKED_OUT | ORA-00061 | The remote portion of a transaction has rolled back. |
INVALID_CURSOR | ORA-01001 | You trIEd to reference a cursor that does not yet exist. This may have happened because you've executed a FETCH cursor or CLOSE cursor before opening the cursor. |
NOT_LOGGED_ON | ORA-01012 | You trIEd to execute a call to Oracle before logging in. |
LOGIN_DENIED | ORA-01017 | You trIEd to log into Oracle with an invalID username/password combination. |
NO_DATA_FOUND | ORA-01403 | You trIEd one of the following:
|
TOO_MANY_ROWS | ORA-01422 | You trIEd to execute a SELECT INTO statement and more than one row was returned. |
ZERO_divIDE | ORA-01476 | You trIEd to divIDe a number by zero. |
INVALID_NUMBER | ora-01722 | You trIEd to execute a sql statement that trIEd to convert a string to a number,but it was unsuccessful. |
STORAGE_ERROR | ORA-06500 | You ran out of memory or memory was corrupted. |
PROGRAM_ERROR | ORA-06501 | This is a generic "Contact Oracle support" message because an internal problem was encountered. |
VALUE_ERROR | ORA-06502 | You trIEd to perform an operation and there was a error on a conversion,truncation,or invalID constraining of numeric or character data. |
CURSOR_ALREADY_OPEN | ORA-06511 | You trIEd to open a cursor that is already open. |
Oracle PL/sql Exception:http://docs.oracle.com/cd/B10500_01/appdev.920/a96624/07_errs.htm
以上是大佬教程为你收集整理的Named system exception in Oracle - Predefined PL/SQL Exceptions全部内容,希望文章能够帮你解决Named system exception in Oracle - Predefined PL/SQL Exceptions所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。