Error Codes In Oracle List
Contents |
the error, the probable cause, and the recommended action. Each error code corresponds to an exception class. See "Runtime and Development Exceptions" for more information. Format:
Sql Error Codes For Oracle Found
A description shown in the actual exception thrown. Cause: The most oracle 11g error codes probable cause for the error. Action: Suggestions for resolving the error. Descriptor Exceptions (1 - 176) Error
Exception No Data Found Oracle
code: 1 ATTRIBUTE_AND_MAPPING_WITH_INDIRECTION_ MISMATCH Cause:
them. SQLSTATE Codes Code Condition Oracle Error 00000 successful completion ORA-00000 01000 warning 01001 cursor operation conflict 01002 disconnect error 01003 null value eliminated https://docs.oracle.com/cd/E15817_01/appdev.111/b31228/appd.htm in set function 01004 string data - right truncation 01005 http://www.dba-oracle.com/t_error_code_list.htm insufficient item descriptor areas 01006 privilege not revoked 01007 privilege not granted 01008 implicit zero-bit padding 01009 search condition too long for info schema 0100A query expression too long for info schema 02000 no data ORA-01095 ORA-01403 07000 dynamic SQL error 07001 using clause error codes does not match parameter specs 07002 using clause does not match target specs 07003 cursor specification cannot be executed 07004 using clause required for dynamic parameters 07005 prepared statement not a cursor specification 07006 restricted datatype attribute violation 07007 using clause required for result fields 07008 invalid descriptor count SQL-02126 07009 invalid descriptor index 08000 connection oracle error codes exception 08001 SQL client unable to establish SQL connection 08002 connection name in use 08003 connection does not exist SQL-02121 08004 SQL server rejected SQL connection 08006 connection failure 08007 transaction resolution unknown 0A000 feature not supported ORA-03000 .. 03099 0A001 multiple server transactions 21000 cardinality violation ORA-01427 SQL-02112 22000 data exception 22001 string data - right truncation ORA-01401 ORA-01406 22002 null value - no indicator parameter ORA-01405 SQL-02124 22003 numeric value out of range ORA-01426 ORA-01438 ORA-01455 ORA-01457 22005 error in assignment 22007 invalid date-time format 22008 date-time field overflow ORA-01800 .. 01899 22009 invalid time zone displacement value 22011 substring error 22012 division by zero ORA-01476 22015 interval field overflow 22018 invalid character value for cast 22019 invalid escape character ORA-00911 ORA-01425 22021 character not in repertoire 22022 indicator overflow ORA-01411 22023 invalid parameter value ORA-01025 ORA-01488 ORA-04000 .. 04019 22024 unterminated C string ORA-01479 .. 01480 22025 invalid escape sequence ORA-01424 22026 string data - length mismatch 22027 trim error 23000 integrity constraint violation ORA-00001 ORA-02290 .. 02299 24000 invalid
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
Oracle Error Code List Oracle Database Tips by Burleson Consulting As of Oracle 10g, Oracle has 10,038 distinct Oracle error codes. This is only includes the ORA- prefix error codes: ORA-00056 ORA-00057 ORA-00058 ORA-00059 ORA-00060 ORA-00061 ORA-00062 ORA-00063 ORA-00064 ORA-00065 ORA-00066 ORA-00067 ORA-00068 ORA-00069 ORA-00070 ORA-00071 ORA-00072 ORA-00073 ORA-00074 ORA-00075 ORA-00076 ORA-00077 ORA-00078 ORA-00079 ORA-00080 ORA-00081 ORA-00082 ORA-00083 ORA-00084 ORA-00085 ORA-00086 ORA-00087 ORA-00088 ORA-00089 ORA-00090 ORA-00091 ORA-00092 ORA-00093 ORA-00094 ORA-00096 ORA-00097 ORA-00117 ORA-00118 ORA-00119 ORA-00120 ORA-00121 ORA-00122 ORA-00123 ORA-00124 ORA-00125 ORA-00126 ORA-00127 ORA-00128 ORA-00129 ORA-00130 ORA-00131 ORA-00132 ORA-00133 ORA-00134 ORA-00150 ORA-00151 ORA-00152 ORA-00153 ORA-00154 ORA-00155 ORA-00160 ORA-00161 ORA-00162 ORA-00163 ORA-00164 ORA-00165 ORA-00166 ORA-00200 ORA-00201 ORA-00202 ORA-00203 ORA-00204 ORA-00205 ORA-00206 ORA-00207 ORA-00208 ORA-00209 ORA-00210 ORA-00211 ORA-00212 ORA-00213 ORA-00214 ORA-00215 ORA-00216 ORA-00217 ORA-00218 ORA-00219 ORA-00220 ORA-00221 ORA-00222 ORA-00223 ORA-00224 ORA-00225 ORA-00226 ORA-00227 ORA-00228 ORA-00229 ORA-00230 ORA-00231 ORA-00232 ORA-00233 ORA-00234 ORA-00235 ORA-00236 ORA-00237 ORA-00238 ORA-00250 ORA-00251 ORA-00252 ORA-00253 ORA-00254 ORA-00255 ORA-00256 ORA-00257 ORA-00258 ORA-00259 ORA-00260 ORA-00261 ORA-00262 ORA-00263 ORA-00264 ORA-00265 ORA-00266 ORA-00267 ORA-00268 ORA-00269 ORA-00270 ORA-00271 ORA-00272 ORA-00273 ORA-00274 ORA-00275 O