# Get SQL error from stored-procedure transaction group

**URL:** <https://forum.inductiveautomation.com/t/get-sql-error-from-stored-procedure-transaction-group/20985>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [November 20, 2018, 9:59pm UTC](https://forum.inductiveautomation.com/t/get-sql-error-from-stored-procedure-transaction-group/20985 "2018-11-20T21:59:46Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![bschroeder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bschroeder/32/13260_2.png) [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\
**Post date:** [November 20, 2018, 9:59pm UTC](https://forum.inductiveautomation.com/t/get-sql-error-from-stored-procedure-transaction-group/20985/1 "2018-11-20T21:59:46Z")

</div>

I’m inserting data into a 3rd party MySQL database using a stored procedure they created and maintain. I’d like to get the error that is generated by their stored procedure if I have an error logging data so I can flag the operator.

They are using the SIGNAL SQLSTATE code and then a message. Is there any way I can capture that to a tag? It shows up in the event area of the transaction group. I’ve tried to shove the return and output param to a string but I can’t seem to do it.

An example of what they are doing is here:

```auto
SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'There are not any active Storage Unit with the specified name';

```

I’d like to capture the MESSAGE\_TEXT part of it. Any possible way to grab it?