Oracle Error Number 100
Contents |
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 sql error code 100
Oracle sqlcode = 100 tips Oracle oracle sql error code 100 Database Tips by Burleson Consulting April 1, 2015 Question: What is the sqlcode 100 in PL/SQL and what Oracle error ora 100 is associated with sqlcode=100. Also, do I have to test for sqlcode=100 directly? Answer: The PL/SQL exception handler will about a PL/SQL program with a ORA-01403 error, regardless of whether you test for sqlcode 100 ora 01403 sqlcode=100. The sqlcode=100 is the most common trapped error in PL/SQL, the "no data found" Boolean expression. For example, if the database returns a SQLCODE=100, the PL/SQL variable NO_DATA_FOUND will be set to TRUE. Get the Complete Oracle SQL Tuning Information The landmark book "Advanced Oracle SQL Tuning The Definitive Reference" is filled with valuable information on Oracle SQL Tuning. This book includes scripts andOra-00100
tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher.
Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications. Errata? Oracle technology is changing and we strive to update our BC Oracle support information. If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail: and include the URL for the page. Burleson Consulting The Oracle of Database Support Oracle Performance Tuning Remote DBA Services Copyright © 1996 - 2016 All rights reserved by Burleson Oracle is the registered trademark of Oracle Corporation. ��Library mySQL Code oracle sqlcode 0 Library PHP Code Library JavaScript Code Library Oracle Terms & Definitions oracle exception sqlcode 100 Oracle Error Codes PSOUG Community Blogs Oracle Jobs Board PSOUG Forum Oracle User Group Directory Free Oracle Magazines http://www.dba-oracle.com/t_sqlcode_100.htm Online Learning Center PSOUG Presentations Advanced Code Search News and Events Sponsors Page Submit Code Contact Us Oracle Error: ORA-00100 Error Description: No data found Error Cause: An application made reference to http://psoug.org/oraerror/ORA-00100.htm unknown or inaccessible data. Action: Handle this condition within the application or make appropriate modifications to the application code. NOTE: If the application uses Oracle-mode SQL instead of ANSI-mode SQL, ORA-01403 will be generated instead of ORA-00100. There haven't been any comments added for this error yet. You may add one if you like. Add a comment Name: Email: URL: Chars left:1000 (1000 max) (No HTML, but newlines will be preserved) Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us 73 users online © 2009 psoug.org PSOUG LOGIN Username: Password: Forgot your password?
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 http://stackoverflow.com/questions/26993948/what-is-this-oracle-code-doing 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 What is this Oracle code doing? up vote 1 down vote favorite I found this article on the Oracle site: Managing Exceptional Behavior, Part 1. In it, someone had defined an error package, with procedures to code 100 raise, handle, report and go, report and stop and log. A breakdown of this package can be found here: errpkg. The part I'm interested in is here: IF l_errcode BETWEEN -20999 AND -20000 THEN raise_application_error (l_errcode, l_errmsg); /* Use positive error numbers -- lots to choose from! */ ELSIF l_errcode > 0 AND l_errcode NOT IN (1, 100) THEN raise_application_error (-20000, l_errcode || '-' || l_errmsg); /* Can't EXCEPTION_INIT -1403 */ ELSIF l_errcode IN (100, -1403) THEN RAISE NO_DATA_FOUND; /* Re-raise sql error code any other exception. */ ELSIF l_errcode != 0 THEN EXECUTE IMMEDIATE 'DECLARE myexc EXCEPTION; ' || ' PRAGMA EXCEPTION_INIT (myexc, ' || TO_CHAR (err_in) || ');' || 'BEGIN RAISE myexc; END;'; END IF; That snippet has been pasted in exactly as it appears in the article. I believe that the first if statement is covering all user errors, as -209999 to -20000 is reserved for user created exceptions. In the first elsif statement (errcode > 0 and not in (1,00)), the code, according to the article, is doing the following: I also handle positive numbers for application-specific error numbers. By handling positive error message numbers, I am not constrained to error numbers between -20,999 and -20,000, some of which Oracle also uses (although I stay away from 1 and 100, the only two positive error numbers that Oracle does use). So to me that sounds like he is happy with declaring errors in his code like 150, 160, 170 etc, provided they don't occur between 1 and 100. However, what are the next two parts of the procedure doing? What is the errcode in (100, -1403) for? I can see it's to do with error code 01403 (no data found), but I don't understand its position in the brackets (100, -1403). And what is the final elsif that does an execute immediate for? I'm struggling to see what its purpose is. sql oracle plsql share|improve this question edited Nov 18 '14 a