OraFAQ Forum: SQL & PL/SQL » Reg:To comeout from the inner blocks

Home » SQL & PL/SQL » SQL & PL/SQL » Reg:To comeout from the inner blocks

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Reg:To comeout from the inner blocks [message #258532]

Mon, 13 August 2007 00:14

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

Report message to a moderator

Re: Reg:To comeout from the inner blocks [message #258546 is a reply to message #258532]

Mon, 13 August 2007 00:59

Frank
Messages: 7901
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.

Report message to a moderator

Re: Reg:To comeout from the inner blocks [message #258551 is a reply to message #258532]

Mon, 13 August 2007 01:08

flyboy
Messages: 1903
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

Report message to a moderator

Previous Topic:	count as a part of the query
Next Topic:	doubt inout procrdure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 11:20:23 CST 2024