File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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

Win a copy of RabbitMQ in Depth this week in the Open Source forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "looking for help re writing a for-loop" Watch "looking for help re writing a for-loop" New topic

looking for help re writing a for-loop

Matt Kohanek
Village Idiot
Ranch Hand

Joined: Apr 04, 2009
Posts: 484

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?




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.

I agree. Here's the link:
subject: looking for help re writing a for-loop