Getting SQLEXCEPTION message in MySQL procedures

Question

How can I get error text in MySQL stored procedure when SQLEXCEPTION occurs?

I need something like this:

DECLARE EXIT HANDLER FOR SQLEXCEPTION    
BEGIN
    INSERT INTO my_log (error_message) 
    VALUES (SQLEXCEPTION.message);
END;

5.1.49 I found that not long ago was added new feature GET DIAGNOSTICS, that solves my problem. — shurik2533
– shurik2533, Commented Oct 25, 2011 at 5:32
GET DIAGNOSTICS is available from 5.6.4. Is there another way for lower version,.? — Praditha
– Praditha, Commented Sep 6, 2012 at 6:32

Rogerio de Moraes · Accepted Answer · 2015-10-05 18:34:02Z

11

DECLARE EXIT HANDLER FOR SQLEXCEPTION    
BEGIN

 GET DIAGNOSTICS CONDITION 1
    @p2 = MESSAGE_TEXT;

    INSERT INTO my_log (error_message) 
    SELECT @p2;
END;

answered Oct 5, 2015 at 18:34

Rogerio de Moraes

1,57718 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting SQLEXCEPTION message in MySQL procedures

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related