MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

Re: Get the code and description of an error within a stored procedure
Posted by: Peter Brawley
Date: November 04, 2017 08:00PM

> would I be able to get the contents of sqlstate without needing
> to tabulate each error code, would I have?

You have three choices (i) upgrade to a version that implements Get Diagnostics, (ii) create a table of sqlstate codes and texts from the sources cited, (iii) tabulate them directly in an sproc.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Get the code and description of an error within a stored procedure
2972
Claudinei Silva
October 31, 2017 07:32PM
Re: Get the code and description of an error within a stored procedure
639
Peter Brawley
October 31, 2017 08:33PM
Re: Get the code and description of an error within a stored procedure
635
Claudinei Silva
October 31, 2017 09:00PM
Re: Get the code and description of an error within a stored procedure
677
Peter Brawley
October 31, 2017 09:30PM
Re: Get the code and description of an error within a stored procedure
1742
Claudinei Silva
November 01, 2017 10:17PM
Re: Get the code and description of an error within a stored procedure
651
Peter Brawley
November 01, 2017 11:08PM
Re: Get the code and description of an error within a stored procedure
694
Claudinei Silva
November 02, 2017 04:06PM
Re: Get the code and description of an error within a stored procedure
662
Peter Brawley
November 02, 2017 04:55PM
Re: Get the code and description of an error within a stored procedure
663
Claudinei Silva
November 02, 2017 06:37PM
Re: Get the code and description of an error within a stored procedure
577
Peter Brawley
November 03, 2017 06:19PM
Re: Get the code and description of an error within a stored procedure
598
Claudinei Silva
November 03, 2017 10:42PM
Re: Get the code and description of an error within a stored procedure
601
Peter Brawley
November 04, 2017 12:13AM
Re: Get the code and description of an error within a stored procedure
652
Claudinei Silva
November 04, 2017 02:46PM
Re: Get the code and description of an error within a stored procedure
596
Peter Brawley
November 04, 2017 08:00PM
Re: Get the code and description of an error within a stored procedure
641
Claudinei Silva
November 04, 2017 09:29PM


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.