OraFAQ Forum: MySQL » Raise Exception

Home » Open Source » MySQL » Raise Exception (5.1.52)

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

Raise Exception [message #568862]

Wed, 17 October 2012 03:49

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,

Attachment: EMAIL_CONTENT_MASTER_PROC.sql
(Size: 1.12KB, Downloaded 2554 times)

Report message to a moderator

Re: Raise Exception [message #568865 is a reply to message #568862]

Wed, 17 October 2012 04:03

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

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

Report message to a moderator

Re: Raise Exception [message #568870 is a reply to message #568865]

Wed, 17 October 2012 04:24

muralikri
Messages: 638
Registered: August 2011
Location: chennai

Senior Member

In MYSQL ,how to handle the execption any error the procedure..

Report message to a moderator

Re: Raise Exception [message #568955 is a reply to message #568870]

Thu, 18 October 2012 01:10

muralikri
Messages: 638
Registered: August 2011
Location: chennai

Senior Member

Any suggestion?any help?

Report message to a moderator

Previous Topic:	Alter Table with check constraint
Next Topic:	Import SQL table in Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 17:59:13 CST 2025