title: pl sql %NOTFOUND
body: <p>I'm just wondering why this piece of code is not working. I don't have any supplier <code>id=1</code> in my table.</p>
  <pre><code>DECLARE
      VAR SUPP_NM VARCHAR(100);
      VAR_SUPP_ID  NUMBER := 1;
      WHILE_VAR CHAR := 'Y';
  BEGIN
      SELECT SUPP_NM
      INTO VAR_SUPP_NM
      FROM TEST.SUPPLIER
      WHERE SUPP_ID = VAR_SUPP_ID;
          
      IF SQL%NOTFOUND THEN
          DBMS_OUTPUT.PUT_LINE('SQL DATA NOT FOUND');
      ELSIF SQL%FOUND THEN
          DBMS_OUTPUT.PUT_LINE('DATA FOUND');
      END IF;    
  END;
  </code></pre>
  <p>I get a 01403 error in Toad but not handled as <code>sql%notfound</code>.</p>
  <p>Why isn't the <code>sql%notfound</code> working?</p>