title: suppress oracle data not found exception
body: <p>I have a unique scenario where-in i need multiple column values to be put into multiple variables. The problem i am facing is that while one column value is present the others needn't be present, hence i end up with DATA NOT FOUND exception, while i want to suppress it and put empty values into the remaining variable. </p>
  
  <pre><code> select nvl(A,''), nvl(B,''), nvl(C,'') 
     into A1, B1, C1  
     from SAMPLE_TABLE 
    where name ='W6';
  </code></pre>
  
  <p>Value of A in the table can be 'hello', Value of B is null and Value of C is null in the table.<br>
  When the statement is executed inside the body of a stored proc i do not want the DATA NOT FOUND Exception, instead i want A1 to have the value 'hello', B1 as '' and C1 as ''. I will be running this dynamically and the where condition keeps changing, hence i do not want to open those many cursors either. Can anyone please let me know how i can accomplish the same?</p>