how to get the error of a stored procedure in sql server

I have a stored procedure that returns several errors in case some condition fails, as I can capture that error, since whenever the procedure fails, it returns a runtime error: invalid memory address or nil pointer dereference, but never the error itself.

3 Likes

You should share some codes here.

– you must be using nil variables somewhere?

2 Likes

Hi, @Mynor2397, that error is not coming from the stored procedure, it’s coming from your Go program somewhere. Like @kync said, you should show the code for us to help you.

2 Likes

This is not related to your problem but I advise you not to use stored procedures at all :grinning:

http://www.tonymarston.net/php-mysql/stored-procedures-are-evil.html

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.