Home » SQL & PL/SQL » SQL & PL/SQL » Reg:To comeout from the inner blocks
Reg:To comeout from the inner blocks [message #258532] Mon, 13 August 2007 00:14 Go to next message
swapnajojo
Messages: 40
Registered: June 2007
Location: India
Member
Hi Team,

I do have two blocks.What can be used to come out of the
program other than'EXIT' from the inner block .

Thanks In Advance
BInuja
Re: Reg:To comeout from the inner blocks [message #258546 is a reply to message #258532] Mon, 13 August 2007 00:59 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Program flow. Good programming means single point of entry and single point of exit.
So, don't scatter your code with return statements, but use well-designed conditional constructs.
Re: Reg:To comeout from the inner blocks [message #258551 is a reply to message #258532] Mon, 13 August 2007 01:08 Go to previous message
flyboy
Messages: 1832
Registered: November 2006
Senior Member
Hi,
could you be more cryptic?
- which "blocks" are you talking about (LOOP or BEGIN-END)?
- what do you mean by "exiting" the program?
- EXIT breaks only the current LOOP so I do not understand your remark about "inner block"
- why do you not post some (even sample or frame) code to demonstrate your doubt?

However I suppose, the answer to your question can be found in PL/SQL Guide and Reference (found eg. on http://tahiti.oracle.com/)
Chapter 13 PL/SQL Language Elements
EXIT Statement
or maybe RETURN Statement
Previous Topic: count as a part of the query
Next Topic: doubt inout procrdure
Goto Forum:
  


Current Time: Sun Dec 04 18:42:26 CST 2016

Total time taken to generate the page: 0.08594 seconds