Ora 100 Oracle Error

Library mySQL Code sqlcode 100 oracle Library PHP Code Library JavaScript Code Library Oracle Terms & Definitions

Ora-00100

Oracle Error Codes PSOUG Community Blogs Oracle Jobs Board PSOUG Forum Oracle User Group Directory Free Oracle Magazines sqlcode 100 ora 01403 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 sqlca.sqlcode powerbuilder 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 67 users online © 2009 psoug.org PSOUG LOGIN Username: Password: Forgot your password?

MySQL MariaDB PostgreSQL SQLite MS Office Excel Access Word Web Development

Sql Server Error 100

HTML CSS Color Picker Languages C Language More ASCII oracle sqlcode 0 Table Linux UNIX Java Clipart Techie Humor Advertisement Oracle Basics ALIASES AND AND

Oracle Exception Sqlcode 100

& OR BETWEEN COMPARISON OPERATORS DELETE DISTINCT EXISTS FROM GROUP BY HAVING IN INSERT INSERT ALL INTERSECT IS NOT NULL IS NULL http://psoug.org/oraerror/ORA-00100.htm JOIN LIKE MINUS NOT OR ORDER BY PIVOT REGEXP_LIKE SELECT SUBQUERY TRUNCATE UNION UNION ALL UPDATE WHERE Oracle Advanced 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 https://www.techonthenet.com/oracle/errors/ora00100.php Oracle / PLSQL: ORA-00100 Error Message Learn the cause and how to resolve the ORA-00100 error message in Oracle. Description When you encounter an ORA-00100 error, the following error message will appear: ORA-00100: no data found Cause An application tried to access data that was either inaccessible or does not exist. Resolution The option(s) to resolve this Oracle error are: Option #1 This error must be handled within the application. Modify the application accordingly. Share this page: Advertisement Back to top Home | About Us | Contact Us | Testimonials | Donate While using this site, you agree to have read and accepted our Terms of Service and Privacy Policy. We use advertisements to support this website and fund the development of new content. Copyright © 2003-2016 TechOnTheNet.com. All rights reserved.

-100 If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register http://www.dbasupport.com/forums/showthread.php?33022-Ora-100 link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 of 3 Thread: Ora -100 Tweet Thread Tools Show http://stackoverflow.com/questions/3940522/why-is-no-data-found-ora-01403-an-exception-in-oracle Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 01-15-2003,03:21 AM #1 immacolato View Profile View Forum Posts Junior Member Join Date code 100 Mar 2002 Posts 5 Ora -100 When I open the application I have Oracle error code -100. What is this? Thank you Reply With Quote 01-15-2003,03:46 AM #2 SANJAY_G View Profile View Forum Posts Senior Advisor Join Date Feb 2000 Location Singapore Posts 1,758 ORA-00100: no data found Cause: An application made reference to unknown or inaccessible data. Action: Handle this condition within the application or make sqlcode 100 ora 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. Sanjay G. Oracle Certified Professional 8i, 9i. "The degree of normality in a database is inversely proportional to that of its DBA" Reply With Quote 01-15-2003,05:17 AM #3 agasimani View Profile View Forum Posts Senior Member Join Date Feb 2001 Location UAE Posts 304 This is a general error, which says the data you are looking for is not found. These kind of errors can be traced only by debugging the application. Give some exercise to your brain and find it out yourself Agasimani OCP(10g/9i/8i/8) Reply With Quote Quick Navigation Oracle Database Administration Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Oracle Forums Oracle Database Administration Oracle Applications DBA Oracle Development Oracle Certification Oracle : How To Oracle Careers Oracle Positions Available Oracle Job Wanted Archives Forum Archives Other Feedback and Questions regarding the forums Obfuscation Unlimited « Previous Thread | Next Thread » Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not edit you

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 Why is no_data_found ORA-01403 an exception in Oracle? up vote 12 down vote favorite 2 If the SELECT INTO statement doesn't return at least one row, ORA-01403 is thrown. For every other DBMS I know this is normal on a SELECT. Only Oracle treats a SELECT INTO like this. CREATE OR REPLACE PROCEDURE no_data_proc IS dummy dual.dummy%TYPE; BEGIN BEGIN SELECT dummy INTO dummy FROM dual WHERE dummy = 'Y'; EXCEPTION WHEN no_data_found THEN dbms_output.put_line('Why is this needed?'); END; END no_data_proc; Why? In my opinion you don't need this exception really. It is too much overhead. Sometimes it is handy but you have to write a whole BEGIN, EXCEPTION, WHEN, END Block. Are there any essential reasons I don't see? oracle exception exception-handling plsql ora-01403 share|improve this question edited Feb 12 '11 at 1:33 OMG Ponies 199k37361417 asked Oct 15 '10 at 8:12 Stephan Schielke 1,11051735 4 Don't forget to catch TOO_MANY_ROWS when the select returns more than one row. –Rene Oct 15 '10 at 13:19 add a comment| 6 Answers 6 active oldest votes up vote 15 down vote accepted The exception block is not needed, you might use it or not, depending on the context. Here you are actively ignoring the exception (the procedure will return successfully) but most of the time if you're doing a SELECT INTO you want it to fail if it doesn't return a row, consider: PROCEDURE update_employee_salary (p_empno) IS l_salary NUMBER; BEGIN SELECT sal INTO l_salary FROM emp WHERE empno = p_empno FOR UPDATE; /* do something with emp data */ END; Here I want my function to fail if it is called with an empno that doesn't exist in the EMP table. I might catch the exception to raise a meaningful error message (with raise_application_error) but most of the time I'm happy with the ORA-01403. In general, the only exceptions you should catch are the expected exceptions (i.e. this should not be the standard to catch all ORA-01403, or all exceptions for that matter). share|improve this answer answered Oct 15 '10 at 8:36 Vincent Malgrat 51.3k770118 The SELECT INT