Re: Error handler only works for first error
It's only speculation (I don't have a MySQL system to test at the moment) but I'm not sure if MySQL Stored Procedures have the concept of block scope in the way other SP languages do.
Aside from that it seems a little odd seeing as your using the IF EXISTS keywords.
What I would do is use a user variable to test which (if any) of the handlers are being used.
Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog
http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information
Subject
Views
Written By
Posted
4590
April 18, 2005 01:39PM
2233
April 18, 2005 02:27PM
Re: Error handler only works for first error
2276
April 19, 2005 02:23AM
3037
May 05, 2005 05:53AM
2303
May 05, 2005 07:16AM
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.