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

[code]    while n_Colomn_Num<=v_SUMQTY loopstrSql4 :=\'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 loopstrSql :=\'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 thenstrSql2 :=\'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;ELSEn_Colomn_Num2 := n_Colomn_Num2 + 1;end if;end loop;n_Colomn_Num := n_Colomn_Num + 1;end loop;