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. |
分享到：
相关推荐
9. **数据库（Database）**：用于存储和管理数据的系统，如MySQL、Oracle和MongoDB。SQL（结构化查询语言）是与数据库交互的主要工具。 10. **API（Application Programming Interface）**：一组预定义的函数、类、...
Oracle数据库是世界上最流行的数据库管理系统之一，它在处理大量数据和复杂事务方面表现出色。然而，如同任何复杂的系统，Oracle也可能遇到各种错误。本篇文章将详细解释这些错误代码及其含义，帮助用户更好地理解和...
它支持多种数据库，如MySQL、PostgreSQL、Oracle等，并具有丰富的函数库，可用于处理图像、文件、加密、网络等多种任务。 **手册内容概述** PHP中文手册是开发者的重要参考资料，包含了PHP的所有核心函数、类、...
Java编程语言是软件开发领域广泛使用的高级编程语言，由Sun Microsystems（现为Oracle Corporation的一部分）于1995年发布。它的设计目标是简洁、通用、面向对象，并且具有垃圾回收机制，使得程序员无需手动管理内存...
4. **异常处理（Exception Handling）**：JAVA通过try-catch-finally语句块进行异常处理，确保程序的健壮性。 5. **输入/输出（I/O）**：JAVA的I/O流系统支持文件操作、网络通信等。 6. **集合框架（Collections ...
其中可能涵盖了命名规则，如变量、类和方法的命名应遵循驼峰命名法，避免使用缩写和保留字；注释的编写，提倡使用清晰、简洁的注释来解释代码的功能和目的；代码结构，如如何组织类和方法，以及如何使用空格和缩进来...
1.3.2 命名空间 10 1.3.3 C#语法格式要点 10 1.3.4 变量 12 1.3.5 类型推断 12 1.3.6 变量的作用域 13 1.3.7 常量 16 1.3.8 流程控制 16 1.3.9 字符串常见操作 21 1.3.10 几个常用的数学函数 27 1.4 .NET的面向对象...
1.3.2 命名空间 10 1.3.3 C#语法格式要点 10 1.3.4 变量 12 1.3.5 类型推断 12 1.3.6 变量的作用域 13 1.3.7 常量 16 1.3.8 流程控制 16 1.3.9 字符串常见操作 21 1.3.10 几个常用的数学函数 27 1.4 .NET的面向对象...
xml Mysql Oracle SqlServer int int NUMBER smallint int(1) smallint(1) NUMBER(2) int memo text CLOB text datetime datetime TIMESTAMP datetime long bigint NUMBER bigint decimal decimal NUMBER(20,2) ...