Home » SQL & PL/SQL » SQL & PL/SQL » Quit from procedure.
Quit from procedure. [message #306263] Thu, 13 March 2008 08:49 Go to next message
fortunethiyagu
Messages: 94
Registered: December 2006
Member

Hi all,

I suppose to run 6 procedures and when anyone throws exception, have to stop the process at that point and quit from executing procedure further.

say, if i am executing 1st & 2nd procedure with out any problem and while trying to execute 3rd got a problem, so i have to stop at that point and quit from executing 4th, 5th and 6th procedure.

How to come out from sp that throws exception?

Thanks in advance.

Fortunethiyagu
Re: Quit from procedure. [message #306264 is a reply to message #306263] Thu, 13 March 2008 09:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
raise_application_error

Regards
Michel
Re: Quit from procedure. [message #306273 is a reply to message #306263] Thu, 13 March 2008 09:25 Go to previous messageGo to next message
fortunethiyagu
Messages: 94
Registered: December 2006
Member

Is there any command like EXIT, RETURN do come out at that moment ...?
Re: Quit from procedure. [message #306275 is a reply to message #306273] Thu, 13 March 2008 09:32 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, but it just returns to the caller that will continue its execution.

Regards
Michel
Previous Topic: select between date
Next Topic: Question with an Analytical Query.
Goto Forum:
  


Current Time: Fri Dec 09 09:57:49 CST 2016

Total time taken to generate the page: 0.06231 seconds