Error Ora-01403 No Data Found Ora-06512
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have ora 01403 no data found ora 06512 in oracle Meta Discuss the workings and policies of this site About Us ora 01403 no data found in forms Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with
Ora 01403 No Data Found 100
us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers,
Ora 01403 No Data Found Insert Statement
just like you, helping each other. Join them; it only takes a minute: Sign up ORACLE: NO DATA FOUND — but data exists up vote 2 down vote favorite Debugging a package procedure and am getting a no data found when there is in fact data. Testing just the SELECT SELECT trim(trailing '/' from GL_SECURITY) as ora-01403 no data found in oracle DUMMY FROM b2k_user@b2k WHERE sms_username = 'FUCHSB'; This happily returns my value : '23706*706' As soon as i try to have this selected INTO i get a NO_DATA _FOUND error (commented out the error handling i put in) set serveroutput on DECLARE p_BAS_user_name varchar2(20); v_gl_inclusion varchar2(1000); v_gl_exclusions varchar2(1000); BEGIN --inputs p_BAS_user_name := 'FUCHSB'; dbms_output.put_line(p_BAS_user_name); ----- GOOD ----- --BEGIN SELECT trim(trailing '/' from GL_SECURITY) as DUMMY INTO v_gl_inclusion FROM b2k_user@b2k WHERE sms_username = p_BAS_user_name; --EXCEPTION -- WHEN NO_DATA_FOUND THEN -- v_gl_inclusion := 'SUPER EFFING STUPID'; --END; dbms_output.put_line(v_gl_inclusion); END; Error report: ORA-01403: no data found ORA-06512: at line 12 01403. 00000 - "no data found" *Cause: *Action: FUCHSB I can catch the error just fine except for the fact that based on the 1st query i know 100% there is a value for FUCHSB in the database. Any ideas.. I'm really starting to despise Oracle. Yes this query is being run over a datalink as seen in the 1st query the data is there. Thanks SOLVED strange beh
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
Ora-01403 No Data Found Select Into
Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs ora-01403 no data found in oracle apps Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, ora-01403 no data found exception handling just like you, helping each other. Join them; it only takes a minute: Sign up PL/SQL block problem: No data found up vote 24 down vote favorite 6 SET SERVEROUTPUT ON DECLARE v_student_id NUMBER := &sv_student_id; v_section_id http://stackoverflow.com/questions/8401785/oracle-no-data-found-but-data-exists NUMBER := 89; v_final_grade NUMBER; v_letter_grade CHAR(1); BEGIN SELECT final_grade INTO v_final_grade FROM enrollment WHERE student_id = v_student_id AND section_id = v_section_id; CASE -- outer CASE WHEN v_final_grade IS NULL THEN DBMS_OUTPUT.PUT_LINE ('There is no final grade.'); ELSE CASE -- inner CASE WHEN v_final_grade >= 90 THEN v_letter_grade := 'A'; WHEN v_final_grade >= 80 THEN v_letter_grade := 'B'; WHEN v_final_grade >= 70 THEN v_letter_grade := 'C'; WHEN v_final_grade >= 60 THEN v_letter_grade := 'D'; http://stackoverflow.com/questions/1256112/pl-sql-block-problem-no-data-found ELSE v_letter_grade := 'F'; END CASE; -- control resumes here after inner CASE terminates DBMS_OUTPUT.PUT_LINE ('Letter grade is: '||v_letter_grade); END CASE; -- control resumes here after outer CASE terminates END; the above code i have taken from the book oracle pl-sql by example fourth edition 2009 my problem is when i enter a student id not present in the table it returns me the following errors Error report: ORA-01403: no data found ORA-06512: at line 7 01403. 00000 - "no data found" *Cause: *Action: but according to book it should have returned a null value and then follow the case flow.. please help me out... thanks in advance sql oracle plsql oracle10g ora-01403 share|improve this question edited Feb 12 '11 at 1:33 OMG Ponies 199k36356415 asked Aug 10 '09 at 17:21 Orapps 136227 Any chance of formatting your PL SQL as code? –pjp Aug 10 '09 at 17:22 Looks nice and pretty now :) –pjp Aug 10 '09 at 17:27 add a comment| 4 Answers 4 active oldest votes up vote 49 down vote accepted When you are selecting INTO a variable and there are no records returned you should get a NO DATA FOUND error. I believe the correct way to write the above code would be to wrap the SELECT statement with it's own BEGIN/EXCEPTION/E
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. You may have to register before you can post: click the register http://www.dbasupport.com/forums/showthread.php?8309-ORA-01403-no-data-found-how-do-you-solve-this 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 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 no data 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 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 no data found 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 Member Join Date Dec 2000 Posts 87 Actually, the problem laid on the trigger that associate with the table, the part starting with select nvl(keypart1_use,'nothing')..... if ....... If I comment out that section there is no problem, just that primary key platformid is not generated. So I'm not too sure if there is something wrong with it. I was trying to do insert as: INSERT INTO Platforms (Platform, DefAssignedToType, KeyPart1_Use, KeyPart2_Use, KeyPart3_Use, Dis