title: Oracle PL/SQL - ORA-01403 “No data found” when using “SELECT INTO”
body: <p>I have a pl sql code that execute three queries sequentially to determine a match level and do some logic
  <BR>The issue is - when first query has no results (completely valid scenario)  I get ORA-01403  No data found.
  <BR>I understand that I need to incorporate [ Exception clause when NO_DATA_FOUND ]- but how to add it and continue to the next query?</p>
  
  <pre><code>PL/SQL Code
       SELECT A into PARAM A FROM SAMPLE WHERE SOME CONDITION;
       --  GOT ORA-01403  No data found HERE 
  
       MATCH_LEVEL =1;
       if A is null then 
            do some logic;
       end if
  
  
       SELECT A INTO PARAM_B FROM SAMPLE WHERE SOME OTHER CONDITION
       MATCH_LEVEL =2
       if A is null then 
            do some logic 2;
       end if
  
  
  
       SELECT A INTO PARAM_B FROM SAMPLE WHERE SOME OTHER CONDITION
       MATCH_LEVEL =3
       if A is null then 
            do some logic 3;
       end if
  
  END    PL/SQL Code
  </code></pre>