MySQL Forums
Forum List  »  Stored Procedures

Help Stored Procedures
Posted by: hellobhaskar
Date: October 31, 2006 04:04AM

Hello All,
I am newbie to mysql stored Procedures. i have a situation
In short its like below


IF(New.Amount > 5000) Then

Show error and Get out
Else
insert .....
End If



can anyone tell me how throw an exception like "throw exception" in PL/SQL and Get out of the Procedure
Thanks in Advance



Edited 2 time(s). Last edit at 10/31/2006 04:13AM by hellobhaskar.

Options: ReplyQuote


Subject
Views
Written By
Posted
Help Stored Procedures
2520
October 31, 2006 04:04AM
1355
October 31, 2006 01:24PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.