looking for help re writing a for-loop

[Matt Kohanek]

Hey guys,

Here is the for loop:

               FOR i IN 1..p_import_lines.COUNT LOOP
                  IF p_import_lines(i).part_number IS NOT NULL AND p_import_lines(i).orig_sys_header_ref = rec.orig_sys_document_ref AND p_import_lines(i).part_number = rec.ordered_item THEN
                     v_line_tbl(j).orig_sys_line_ref := p_import_lines(i).orig_sys_line_ref;
                  END IF;
               END LOOP;

I would like the loop to end once the IF statement inside of it evaluates to true (or once v_line_tbl(i).orig_sys_line_ref is no longer NULL, same difference).

I know there is a simple way to accomplish this from the tutorials I used to teach myself pl sql, but I have not found it and cannot remember it.

Can anyone point me in the right direction please?

SOLUTION -

EXIT;

:\

I was trying EXIT LOOP; this whole time and could not fogure out why it was not working hahaha

[Agador Paloi]

Matt -
you can also code EXIT WHEN conition to accomplish the same thing.


Agad