MySQL Forums
Forum List  »  Newbie

Re: how can i get the error decription like SQLERRM in oracle within a stored procedure
Posted by: Andrew Gilfrin
Date: February 06, 2005 04:44AM

Ralf

OK I check it out. It seems to use individual error messages first and then SQLSTATE. So if we declare 2 handlers, one for SQLTATE 23000 and one for error_message 1062 (duplicate value which comes under SQLSTATE 23000) it will raise the 1062 handler rather than SQLSTATE 23000. This ignores the order in which you declare the handlers.

To save repeating code you can see an example of the source code action on my site here http://mysql.gilfster.com/tutorials/handlers.php

Cheers

Andrew Gilfrin
http://www.mysqldevelopment.com

Options: ReplyQuote


Subject
Written By
Posted
Re: how can i get the error decription like SQLERRM in oracle within a stored procedure
February 06, 2005 04:44AM


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.