title: How to continue when no_data_found exception raised?
body: <p>I have a value that i dont know exactly in which column it is inserted. I can determine that since this table columns are named as C1....C99. I am going to find the column using the following code. <strong>But when the no data found exception is called, I cant start my loop again.</strong></p>
  
  <pre><code>DECLARE
     i number:=1;
     k boolean := true;
     output number;
     stmt varchar(500);
  BEGIN
    &lt;&lt;repeat&gt;&gt;
    while(k)
    loop
      DBMS_OUTPUT.PUT_LINE( 'c column --&gt;'||i );
     EXECUTE IMMEDIATE 'select 1 from X_TAB t where t.c'||i||'= ''NOTE_NFE'''
  
       into output;
       IF output = 1 then
          DBMS_OUTPUT.PUT_LINE( 'c column'||i );
          k:=false;
       END IF;
       i:=i+1;
       IF i = 100 then
          k:=false;
       END IF;
  END LOOP;
  EXCEPTION 
       when no_data_found then
         i:=i+1;
         if i = 100 then
            k:=false;
         end if;
         goto repeat;
  END;
  /
  </code></pre>