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
3280
Claudinei Silva
October 31, 2017 07:32PM
Re: Get the code and description of an error within a stored procedure
798
Peter Brawley
October 31, 2017 08:33PM
Re: Get the code and description of an error within a stored procedure
781
Claudinei Silva
October 31, 2017 09:00PM
Re: Get the code and description of an error within a stored procedure
820
Peter Brawley
October 31, 2017 09:30PM
Re: Get the code and description of an error within a stored procedure
2050
Claudinei Silva
November 01, 2017 10:17PM
Re: Get the code and description of an error within a stored procedure
789
Peter Brawley
November 01, 2017 11:08PM
Re: Get the code and description of an error within a stored procedure
888
Claudinei Silva
November 02, 2017 04:06PM
Re: Get the code and description of an error within a stored procedure
838
Peter Brawley
November 02, 2017 04:55PM
Re: Get the code and description of an error within a stored procedure
835
Claudinei Silva
November 02, 2017 06:37PM
Re: Get the code and description of an error within a stored procedure
751
Peter Brawley
November 03, 2017 06:19PM
Re: Get the code and description of an error within a stored procedure
753
Claudinei Silva
November 03, 2017 10:42PM
Re: Get the code and description of an error within a stored procedure
795
Peter Brawley
November 04, 2017 12:13AM
Re: Get the code and description of an error within a stored procedure
826
Claudinei Silva
November 04, 2017 02:46PM
Re: Get the code and description of an error within a stored procedure
816
Peter Brawley
November 04, 2017 08:00PM
Re: Get the code and description of an error within a stored procedure
812
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.