Oracle Sql Error Message Code
Contents |
and other
Oracle Sql Error Codes
troubleshooting information in these books. List of Message Types oracle error codes list with description 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 Handling
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 oracle sqlcode list 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 codes table 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.
MySQL MariaDB PostgreSQL SQLite MS Office Excel Access Word https://www.techonthenet.com/oracle/errors/ Web Development HTML CSS Color Picker Languages C Language More ASCII Table Linux UNIX Java Clipart Techie Humor Advertisement Oracle Basics http://stackoverflow.com/questions/1239164/providing-a-more-meaningful-message-when-an-error-is-raised-in-pl-sql Oracle Advanced Alter Table Alter Tablespace Change Password Check Constraints Comments in SQL Create Schema Create Schema Statement Create Table Create oracle sql Table As Create Tablespace Create User Data Types Declare Variables Drop Table Drop Tablespace Drop User Error Messages Find Default Tablespace Find Users Find Users Logged In Find Version Information Functions Global Temporary Grant/Revoke Privileges Indexes Literals Local Temporary Primary Keys Procedures oracle error codes Roles Sequences Set Default Tablespace Synonyms System Tables Unique Constraints Views Oracle Cursors Oracle Exception Handling Oracle Foreign Keys Oracle Loops/Conditionals Oracle Transactions Oracle Triggers String/Char Functions Numeric/Math Functions Date/Time Functions Conversion Functions Analytic Functions Advanced Functions NEXT: TUTORIAL COMPLETE Oracle / PLSQL: Oracle Error Messages The following is a listing of Oracle Error Messages: 00001-00899 ORA-00001 ORA-00018 ORA-00020 ORA-00023 ORA-00028 ORA-00034 ORA-00051 ORA-00054 ORA-00057 ORA-00058 ORA-00060 ORA-00063 ORA-00068 ORA-00071 ORA-00078 ORA-00100 ORA-00107 ORA-00201 ORA-00257 ORA-00301 ORA-00304 ORA-00361 ORA-00401 00900-00999 ORA-00900 ORA-00902 ORA-00903 ORA-00904 ORA-00905 ORA-00906 ORA-00907 ORA-00908 ORA-00909 ORA-00910 ORA-00911 ORA-00913 ORA-00917 ORA-00918 ORA-00919 ORA-00920 ORA-00923 ORA-00924 ORA-00925 ORA-00926 ORA-00927 ORA-00928 ORA-00931 ORA-00932 ORA-00933 ORA-00934 ORA-00935 ORA-00936 ORA-00937 ORA-00938 ORA-00939 ORA-00942 ORA-00946 ORA-00947 ORA-00948 ORA-00955 ORA-00957 ORA-00960 ORA-00962 ORA-00971 ORA-00972 ORA-00975 ORA-00979 ORA-00
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Providing a more meaningful message when an error is raised in PL/SQL up vote 2 down vote favorite 1 Suppose I have a PL/SQL function that selects one value from a table. If the query returns no records, I wish for the NO_DATA_FOUND error to propagate (so that the calling code can catch it), but with a more meaningful error message when SQLERRM is called. Here is an example of what I am trying to accomplish: FUNCTION fetch_customer_id(customer_name VARCHAR2) RETURN NUMBER; customer_id NUMBER; BEGIN SELECT customer_id INTO customer_id FROM CUSTOMERS WHERE customer_name = fetch_customer_id.customer_name; RETURN customer_id; EXCEPTION WHEN NO_DATA_FOUND THEN meaningful_error_message := 'Customer named ' || customer_name || ' does not exist'; RAISE; END; Is there a way to associate meaningful_error_message with the NO_DATA_FOUND error? Update: It has been suggested that I use RAISE_APPLICATION_ERROR to raise a custom error code when NO_DATA_FOUND is encountered. The purpose of this question was to determine if this technique could be avoided so that the calling code can catch NO_DATA_FOUND errors rather than a custom error code. Catching NO_DATA_FOUND seems more semantically correct, but I could be wrong. oracle error-handling plsql share|improve this question edited Aug 6 '09 at 14:41 asked Aug 6 '09 at 14:15 Adam Paynter 29.8k18109144 add a comment| 2 Answers 2 active oldest votes up vote 7 down vote accepted Use RAISE_APPLICATION_ERROR (-20001, 'your message'); This will return an error number -20001, and your message instead of the NO_DATA_FOUND message. Oracle has reserved the error numbers between -20001 and -210000 for user use in their applications, so you won't be hiding another Oracle error by using these numbers. EDIT: RAISE_APPLICATION_ERROR is specifically designed to allow you to create your own error messages. So Oracle does not have another method of allowing dynamic error messages. To further refine this you can