Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

looking for help re writing a for-loop

 
Matt Kohanek
Village Idiot
Ranch Hand
Posts: 484
Java jQuery Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hey guys,

Here is the for 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
Ranch Hand
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Matt -
you can also code EXIT WHEN conition to accomplish the same thing.


Agad
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic