Handling RAISERROR from executing a stored procedure

When executing a stored procedure I need to display the message that comes from the RAISERROR statement, but all I can get OutSystems to display is "Error executing query."

How can I capture the error message coming from the stored procedure and display that on the front end?


We're on platform 11, on-premises

Hi Isaac,

 When you call a stored procedure , create a seprate action for this and handle error exception and set abort transcation property no.

After that bind a list for input and outpur parameter list like below image-


When SP getting any error pass this error in ouput list and show this message accordingly.


Like below image


Hope this will help you.

Kind Regard

Rahul Sahu

Solution

I ended up wrapping my stored procedure call in a Try/Catch and just selected the ERROR_MESSAGE().

Then I'm raising and exception if the error message ins't an empty string and setting the exception message to the value coming from ERROR_MESSAGE().

Thanks Rahul, you helped set me on the right path.

Solution