Home » Open Source » MySQL » Raise Exception (5.1.52)
Raise Exception [message #568862] Wed, 17 October 2012 03:49 Go to next message
muralikri
Messages: 638
Registered: August 2011
Location: chennai
Senior Member

Hi All,

How to handle the any exception in the procedure as like oracle(OTHERS).
if any error while insert/update in the procedure,need to be fail entire procedure.
i tried in google not getting proper answer....

Find the attached procedure.

Thanks,
Re: Raise Exception [message #568865 is a reply to message #568862] Wed, 17 October 2012 04:03 Go to previous messageGo to next message
Michel Cadot
Messages: 58847
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OTHERS should not be done in Oracle.
Should it be in MySQL, I doubt for about the same reason(s).

Regards
Michel
Re: Raise Exception [message #568870 is a reply to message #568865] Wed, 17 October 2012 04:24 Go to previous messageGo to next message
muralikri
Messages: 638
Registered: August 2011
Location: chennai
Senior Member

In MYSQL ,how to handle the execption any error the procedure..
Re: Raise Exception [message #568955 is a reply to message #568870] Thu, 18 October 2012 01:10 Go to previous message
muralikri
Messages: 638
Registered: August 2011
Location: chennai
Senior Member

Any suggestion?any help?
Previous Topic: Alter Table with check constraint
Next Topic: Import SQL table in Oracle
Goto Forum:
  


Current Time: Wed Aug 20 23:21:14 CDT 2014

Total time taken to generate the page: 0.12088 seconds