Error Ora-01403 No Data Found
Contents |
easiest fix would be is to handle the error in the PL/SQL block, When a SQL statement is written within a PL/SQL block, ora 01403 no data found ora 06512 in oracle enclose the SQL with a BEGIN and END statement. Handle the exception
Ora 01403 No Data Found In Forms
and raise a user-friendly message or handle the rest of the processing. Eg: CREATE OR REPLACE PROCEDURE test_proc (p_empno
Ora-01403 No Data Found In Package
IN NUMBER) IS l_empname VARCHAR2(50); BEGIN SELECT empname INTO l_empname FROM emp WHERE empno = p_empno; IF l_empname = 'Sarah Jones' THEN INSERT INTO empresult values ('105', 'Found Sarah Jones');
Ora-01403 No Data Found In Oracle Apps
END IF; END; / The above procedure has not handled the error that would be raised if the select statement did not find the specified empno. See the following for the error raised: SQL> exec test_proc (1) begin test_proc (1); end; * ERROR at line 1: ORA-01403: no data found ORA-06512: at "TAROT.TEST_PROC", line 4 ORA-06512: at line 1 If you ora-01403 no data found select into want the procedure to execute properly without errors on the screen, then you would have to handle the error. The Exception needs to be controlled by adding an exception handler to the code. The above code has been modified to handle an exception NO_DATA_FOUND. This is the name of the exception that the error relates to. CREATE OR REPLACE PROCEDURE test_proc (p_empno IN NUMBER) IS l_empname VARCHAR2(50); BEGIN SELECT empname INTO l_empname FROM emp WHERE empno = p_empno; IF l_empname = 'Sarah Jones' THEN INSERT INTO empresult values ('105', 'Found Sarah Jones'); END IF; EXCEPTION WHEN NO_DATA_FOUND THEN INSERT INTO empresult values(p_empno, 'Did not find Sarah Jones'); END; / If you execute the above procedure now, this is what you would see: SQL> exec test_proc (1) PL/SQL procedure successfully completed. SQL> select * 2 from empresult; EMPNO EMPNAME --------- -------------------------------------------------- 1 Did not find Sarah Jones As the exception was handled, a row was inserted into the empresult table with the error message you specified. When the exception is raised, the control jumps from the select statement to the exception handler rout
MySQL MariaDB PostgreSQL SQLite MS Office Excel Access Word Web Development HTML CSS Color ora-01403 no data found ora-06512 Picker Languages C Language More ASCII Table Linux UNIX ora-01403 no data found exception handling Java Clipart Techie Humor Advertisement Oracle Basics ALIASES AND AND & OR BETWEEN COMPARISON ora-01403 no data found apex OPERATORS DELETE DISTINCT EXISTS FROM GROUP BY HAVING IN INSERT INSERT ALL INTERSECT IS NOT NULL IS NULL JOIN LIKE MINUS NOT OR http://www.orafaq.com/wiki/ORA-01403 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 Oracle / PLSQL: ORA-01403 Error Message Learn https://www.techonthenet.com/oracle/errors/ora01403.php the cause and how to resolve the ORA-01403 error message in Oracle. Description When you encounter an ORA-01403 error, the following error message will appear: ORA-01403: no data found Cause You tried one of the following: You executed a SELECT INTO statement and no rows were returned. You referenced an uninitialized row in a table. You read past the end of file with the UTL_FILE package. Resolution The option(s) to resolve this Oracle error are: Option #1 Terminate processing of the data. 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.
data found, how do you solve this? If this is your first visit, be sure to check out the FAQ by clicking the link above. http://www.dbasupport.com/forums/showthread.php?8309-ORA-01403-no-data-found-how-do-you-solve-this You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Page 1 of 2 12 Last Jump to page: Results 1 to 10 of 13 Thread: ORA-01403: no data found, how do you solve this? Tweet Thread no data Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 03-22-2001,02:37 PM #1 coolmandba View Profile View Forum Posts Junior Member Join Date Dec 2000 Posts 87 Hi all, I'm trying do a 'INSERT' into a table and I received this message... ORA-01403: no data found What does no data found it mean, and how do you solve it? Thanks. Reply With Quote 03-22-2001,03:14 PM #2 irehman View Profile View Forum Posts Senior Member Join Date Dec 2000 Location Virginia, USA Posts 455 I got this from Oracle Book. I don't know if this will help you. ORA-01403 no data found Cause: In a host language program, all records have been fetched. The return code from the fetch was +4, indicating that all records have been returned from the SQL query. Action: Terminate processing for the SELECT statement. Reply With Quote 03-22-2001,03:19 PM #3 coolmandba View Profile View Forum Posts Junior Member Join Date Dec 2000 Posts 87 Thanks. I also checked the documentation and yield exact the same content as what you got here, but it still doesn't solve my problem. Reply With Quote 03-22-2001,03:21 PM #4 irehman View Profile View Forum Posts Senior Member Join Date Dec 2000 Location Virginia, USA Posts 455 Can you post your insert statement with Table Defination? Reply With Quote 03-22-2001,03:48 PM #5 coolmandba View Profile View Forum Posts Junior