http://www.techonthenet.com/oracle/exceptions/named_system.php
Oracle Exception NameOracle ErrorExplanation
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:
- You executed a SELECT INTO statement and no rows were returned.
- You referenced an uninitialized row in a table.
- You read past the end of file with the UTL_FILE package.
|
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 an 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数据库命名规范.ORACLE数据库命名规范.ORACLE数据库命名规范.
经过长时间的查询,终于把oracle的所有出现的异常统计出来,希望对你有好处。谢谢
Oracle数据库命名规范
oracle预定义异常, ORACLE开发存储过程,函数,触发器等程序时,会经常使用到异常处理,该文档列举了常见的异常以及异常说明
安装oracle'程序异常终止'问题,解决安装oracle中遇到的问题
JAVA ORACLE 网吧计费系统 JAVA ORACLE 网吧计费系统 JAVA ORACLE 网吧计费系统 JAVA ORACLE 网吧计费系统 JAVA ORACLE 网吧计费系统 JAVA ORACLE 网吧计费系统 JAVA ORACLE 网吧计费系统 JAVA ORACLE 网吧计费系统 ...
介绍Oracle命名方法配置,可供参考!
Oracle预定义的21个系统异常类型
ORACLE数据库命名编码规范 ORACLE数据库命名编码规范
Oracle 图书管理信息系统报告Oracle 图书管理信息系统报告Oracle 图书管理信息系统报告Oracle 图书管理信息系统报告Oracle 图书管理信息系统报告Oracle 图书管理信息系统报告Oracle 图书管理信息系统报告Oracle 图书...
详细介绍 ORACLE 异常错误处理异常错误处理异常错误处理
oracle笔记异常处理,异常处理的代码案例和知识点笔记!
Oracle代码编写过程中,如果捕捉例外则会在plsql块内解决运行错误,否则将错误传递到调用环境。
ORACLE 用户自定义异常小例子 1.进入pl/sql测试窗口 2.执行语句 declare empname varchar2(255); customize_exp EXCEPTION; –自定义异常 begin FOR c IN (select d.* from scott.dept d) ...
ORACLE主要的系统表和系统视图.pdf
oracle异常信息对照表,希望对大家有帮助。
《Oracle大型数据库系统在AIX/UNIX上的实战详解》以AIX UNIX平台为主线,以其他UNIX系统为参照,描述了数据库系统Oracle 10g、Oracle 11g的构架方法,说明了该数据库在AIX平台常用的管理内容,提供了AIX上实施Oracle...
oracle图书管理信息系统,内含 源代码 三结构图,运行视频,答辩PPT等 。希望帮助你的学习。祝你成功
命名的系统异常 产生原因 ACCESS_INTO_NULL 未定义对象 CASE_NOT_FOUND CASE 中若未包含相应的 WHEN ,并且没有设置 ELSE 时 COLLECTION_IS_NULL 集合元素未初始化 CURSER_ALREADY_OPEN 游标已经打开 DUP_VAL_...