OraFAQ Forum: SQL & PL/SQL » exiting plsql block

Home » SQL & PL/SQL » SQL & PL/SQL » exiting plsql block (oracle plsql,9i,xp)

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

exiting plsql block [message #346570]

Mon, 08 September 2008 23:11

yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait

Senior Member

Hi,

Is there a way to exit plsql block if something goes wrong.
i want this to happen in normal plsql block not inside loop. In vb we can use exit sub. is there anythin of that kind here?

Thanks in Advance Smile

Report message to a moderator

Re: exiting plsql block [message #346572 is a reply to message #346570]

Mon, 08 September 2008 23:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

Unwilling or incapable to Read The Fine Manual?

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/exit_statement.htm#sthref2700

>Is there a way to exit plsql block if something goes wrong.
How do you determine when "something goes wrong"?

[Updated on: Mon, 08 September 2008 23:18] by Moderator

Report message to a moderator

Re: exiting plsql block [message #346575 is a reply to message #346570]

Mon, 08 September 2008 23:24

Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Maybe RETURN

Regards
Michel

Report message to a moderator

Re: exiting plsql block [message #346601 is a reply to message #346575]

Tue, 09 September 2008 01:46

milind.khadloya
Messages: 4
Registered: September 2008
Location: India

Junior Member

Exception (error handling) block can be use for this purpose. You can define your own exception and raise the same at particular condition.

Report message to a moderator

Re: exiting plsql block [message #347610 is a reply to message #346572]

Fri, 12 September 2008 05:48

yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait

Senior Member

I am sorry anacedent. Actually what i thought was if someone can just give me alink to that or tell me i dont have to spend time on that. That was what in my mind.

Report message to a moderator

Re: exiting plsql block [message #347611 is a reply to message #346601]

Fri, 12 September 2008 05:50

yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait

Senior Member

Thanks Milind. That is very helpful and now i am handling very gracefully.

Report message to a moderator

Previous Topic:	send a mail from pl/sql
Next Topic:	ORA-12043: invalid CREATE MATERIALIZED VIEW option

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Aug 27 09:39:00 CDT 2025