title: ORA-01403: no data found for Select into
body: <p>I am getting <code>ORA-01403: no data found</code> exception for the following query. What are the possibilities of this error?</p>
  
  <pre><code>SELECT trim(name)
    INTO fullname
    FROM ( SELECT n.name
           FROM directory dir, store n
          WHERE dir.name = n.name
            AND dir.status NOT IN ('F', 'L', 'M')
          ORDER BY n.imp, dir.date)
    WHERE rownum &lt;= 1;
  </code></pre>
  
  <p>How can I handle this error?</p>