aspose file tools*
The moose likes JDBC and the fly likes looking for help re writing a for-loop Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "looking for help re writing a for-loop" Watch "looking for help re writing a for-loop" New topic
Author

looking for help re writing a for-loop

Matt Kohanek
Village Idiot
Ranch Hand

Joined: Apr 04, 2009
Posts: 483

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


True wisdom is in knowing you know nothing - Socrates
Agador Paloi
Ranch Hand

Joined: Jan 24, 2006
Posts: 118
Matt -
you can also code EXIT WHEN conition to accomplish the same thing.


Agad
 
Consider Paul's rocket mass heater.
 
subject: looking for help re writing a for-loop