Oracle Sql Error List
Contents |
and other oracle error codes list with description troubleshooting information in these books. List of Message Types
Oracle Error Codes Table
ORA-00000 to ORA-00899 ORA-00900 to ORA-01499 ORA-01500 to ORA-02099 ORA-02100 to ORA-04099 ORA-04100 to
Oracle Error Codes And Solution
ORA-07499 ORA-07500 to ORA-09857 ORA-09858 to ORA-12299 ORA-12300 to ORA-12399 ORA-12400 to ORA-12699 ORA-12700 to ORA-19399 ORA-19400 to ORA-24279 ORA-24280 to ORA-29249
Ora Errors And Solutions
ORA-29250 to ORA-32799 ORA-32800 to ORA-32999 ORA-33000 to ORA-65535 BFILE-Related Messages (LFI) DBNEWID Messages (NID) DBVERIFY Messages (DBV) Export Messages (EXP) External Naming Messages (NNF) External Tables Messages (KUP) Import Messages (IMP) interMedia Audio Messages (AUD) interMedia Image Messages (IMG) interMedia Video Messages (VID) Network oracle error handling Security Messages (NZE) Object Type Translator Initialization Messages (O2I) Object Type Translator Type File Messages (O2F) Object Type Translator Unparser Messages (O2U) Oracle Names Client Messages (NNC) Oracle Names Control Utility Messages (NNL) Oracle Names Server Messages (NNO) Oracle Names Server Network Presentation Layer Messages (NPL) Oracle Net Messages (TNS) Oracle OLAP Catalog Metadata Messages (AMD) Oracle Text Messages (DRG) Oracle Trace Collection Services Messages (EPC) Parameter Messages (LCD) Parameter Messages (LRM) PCF FIPS Messages (PCF) PL/SQL and FIPS Messages (PLS) Pro*C/C++ Messages (PCC) Pro*COBOL Messages (PCB) Recovery Manager Messages (RMAN) Remote Operation Messages (NCR) Simple Network Management Protocol Messages (NMP) SQL Runtime Messages (SQL) SQL*Module Messages (MOD) Summary Advisor, Explain Rewrite, and Explain Materialized View Messages (QSM) XML Parser Messages (LPX) XML Schema Processor Messages (LSX) Copyright © 2016, Oracle. All rights reserved.
Churchill Run-time errors arise from design faults, coding mistakes, hardware failures, and many other sources. Although you cannot anticipate all possible errors, you can plan to ora error 12154 handle certain kinds of errors meaningful to your PL/SQL program. With many programming ora in oracle languages, unless you disable error checking, a run-time error such as stack overflow or division by zero stops normal oracle error code 942 processing and returns control to the operating system. With PL/SQL, a mechanism called exception handling lets you "bulletproof" your program so that it can continue operating in the presence of errors. http://www.oracle.com/pls/db92/db92.error_search?prefill=ORA- This chapter discusses the following topics: Overview of PL/SQL Error Handling Advantages of PL/SQL Exceptions Predefined PL/SQL Exceptions Defining Your Own PL/SQL Exceptions How PL/SQL Exceptions Are Raised How PL/SQL Exceptions Propagate Reraising a PL/SQL Exception Handling Raised PL/SQL Exceptions Tips for Handling PL/SQL Errors Overview of PL/SQL Error Handling In PL/SQL, a warning or error condition is called an exception. Exceptions can be https://docs.oracle.com/cd/A97630_01/appdev.920/a96624/07_errs.htm internally defined (by the run-time system) or user defined. Examples of internally defined exceptions include division by zero and out of memory. Some common internal exceptions have predefined names, such as ZERO_DIVIDE and STORAGE_ERROR. The other internal exceptions can be given names. You can define exceptions of your own in the declarative part of any PL/SQL block, subprogram, or package. For example, you might define an exception named insufficient_funds to flag overdrawn bank accounts. Unlike internal exceptions, user-defined exceptions must be given names. When an error occurs, an exception is raised. That is, normal execution stops and control transfers to the exception-handling part of your PL/SQL block or subprogram. Internal exceptions are raised implicitly (automatically) by the run-time system. User-defined exceptions must be raised explicitly by RAISE statements, which can also raise predefined exceptions. To handle raised exceptions, you write separate routines called exception handlers. After an exception handler runs, the current block stops executing and the enclosing block resumes with the next statement. If there is no enclosing block, control returns to the host environment. In the example below, you calculate and store a price-to-earnings ratio f
Code Library mySQL Code Library PHP Code Library JavaScript Code Library Oracle Terms & http://psoug.org/oraerror.htm Definitions Oracle Error Codes PSOUG Community Blogs Oracle Jobs Board PSOUG Forum Oracle User Group Directory Free Oracle Magazines Online Learning Center PSOUG Presentations Advanced Code Search News and Events Sponsors Page Submit Code Contact Us We have over 18,000 Oracle Error Codes currently indexed for searching, including error oracle error codes for SQL*Loader, RMAN, NNL, TNS, DRG, IMG, PCC, LPX, LSX, and many others. Type the Oracle Error code into the Search box to find the associated error: Or, browse the Oracle Error list below: ORA-00000: Normal, successful completion ORA-00001: Unique constraint (string.string) violated ORA-00017: Session requested to set trace event ORA-00018: oracle error code Maximum number of sessions exceeded ORA-00019: Maximum number of session licenses exceeded ORA-00020: Maximum number of processes (string) exceeded ORA-00021: Session attached to some other process; cannot ... ORA-00022: Invalid session ID; access denied ORA-00023: Session references process private memory; cann... ORA-00024: Logins from more than one process not allowed i... ORA-00025: Failed to allocate string ORA-00026: Missing or invalid session ID ORA-00027: Cannot kill current session ORA-00028: Your session has been killed ORA-00029: Session is not a user session ORA-00030: User session ID does not exist. ORA-00031: Session marked for kill ORA-00032: Invalid session migration password ORA-00033: Current session has empty migration password ORA-00034: Cannot string in current PL/SQL session ORA-00036: Maximum number of recursive SQL levels (string)... ORA-00037: Cannot switch to a session belonging to a diffe... ORA-00038: Cannot create session: server group belongs to ... ORA-00040: Active time limit exceeded - call aborted ORA-00041: Active time limit exceeded - session terminated ORA-00042: Unknown Service name string ORA-00050: Operatin
be down. Please try the request again. Your cache administrator is webmaster. Generated Sun, 23 Oct 2016 17:35:09 GMT by s_wx1085 (squid/3.5.20)