How to get internal exception error message in storedproc



I’m getting some exceptions while processing data in my stored procedure. I would like to log exact error/exception message thrown by memsql when exception occurs.

I tried using EXCEPTION_MESSAGE() but of no use, looks like it only captures user defined exception error messages not internal exceptions.



I think that’s a bug. I’ll bring this up with the team and see if we can get it fixed.

It would also be good to be able to get the output of SHOW ERRORS in a stored procedure, say by showing the same information in a management view. I’ll make a note of that for future planning.


Thank you hanson for taking this up.