Oracle pl/sql的嵌套while循环和exit跳出循环

    while n_Colomn_Num<=v_SUMQTY loop
	        strSql4 :='select NOTE_'|| to_char(n_Colomn_Num) ||' from JCD_PLAN_TEMP_ONE WHERE PROCESSNAME = ''' || v_ITEMNAME || ''' And PANELPCS = ''' || v_PANELPCS || ''' AND KEYNAME = ''1''';
          EXECUTE IMMEDIATE strSql4 INTO v_TEMPSTEPNAME1; 
          
          n_Colomn_Num2 := 1;

    while n_Colomn_Num2<=80 loop
           
           strSql :='select NOTE_'|| to_char(n_Colomn_Num2) ||' from JCD_PLAN_TEMP_TWO WHERE KEYNAME = ''1''';
           EXECUTE IMMEDIATE strSql INTO v_TEMPSTEPNAME2;
           
           if v_TEMPSTEPNAME1=v_TEMPSTEPNAME2 then
             
             strSql2 :='select NOTE_'|| to_char(n_Colomn_Num) ||' from JCD_PLAN_TEMP_ONE WHERE PROCESSNAME = ''' || v_ITEMNAME || ''' And PANELPCS = ''' || v_PANELPCS || ''' And KEYNAME = ''4''';
             EXECUTE IMMEDIATE strSql2 INTO v_TEMPQTY;
           
	           strSql3 := 'UPDATE JCD_PLAN_TEMP_TWO SET NOTE_' || to_char(n_Colomn_Num2) || ' = ''' || v_TEMPQTY ;                 
             strSql3 := strSql3 || ''' WHERE PROCESSNAME = ''' || v_ITEMNAME || ''' And PANELPCS = ''' || v_PANELPCS || ''' And KEYNAME = ''2''';
             EXECUTE IMMEDIATE strSql3;
             
             exit;
             
           ELSE
             n_Colomn_Num2 := n_Colomn_Num2 + 1;
           end if;

    end loop;
    n_Colomn_Num := n_Colomn_Num + 1;
   end loop;