Oracle Error Code Message
Contents |
and other oracle error sqlcode troubleshooting information in these books. List of Message Types oracle sql error codes 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 list with description 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 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.
the error, the probable cause, and the recommended action. Each error code corresponds to an exception class. See "Runtime and https://docs.oracle.com/cd/A97688_16/toplink.903/b10068/errorcod.htm Development Exceptions" for more information. Format: A description shown in the actual exception thrown. Cause: The most probable cause for the error. Action: Suggestions for http://stackoverflow.com/questions/8598601/return-message-of-error-code-in-oracle-stored-proc resolving the error. Descriptor Exceptions (1 - 176) Error code: 1 ATTRIBUTE_AND_MAPPING_WITH_INDIRECTION_ MISMATCH Cause:
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 Return Message of Error code in Oracle Stored Proc up vote 0 down vote favorite 1 The below procedure (in Oracle 11g release 1) accepts a sql as a parameter & returns its return code. Returns 0 if success Returns 1 if no update or no delete performs Returns actual error code in case of failure. How can I change below procedure to return me another out param say "return_message" which will contain short description of oracle internal error message? In case of success, it should say "success" and in case no delete/updates performed, it should say "nochange" CREATE OR REPLACE PROCEDURE "demo"."run_demo"(v_sql IN VARCHAR2, return_code OUT number) AS i number; BEGIN return_code := 0; execute immediate v_sql; i := sql%rowcount; IF (i<1) THEN return_code := 1; END IF; EXCEPTION WHEN OTHERS THEN return_code := SQLCODE; END; oracle oracle10g oracle11g oracle9i share|improve this question asked Dec 22 '11 at 1:48 Mike 1,780104969 add a comment| 2 Answers 2 active oldest votes up vote 6 down vote accepted You want to use the SQLERRM function. Here's your code: CREATE OR REPLACE PROCEDURE "demo"."run_demo"(v_sql IN VARCHAR2, return_code OUT number, return_message out varchar2) AS i number; BEGIN return_code := 0; execute immediate v_sql; i := sql%rowcount; IF (i<1) THEN return_code := 1; END