Show Error on WebApp Page from Stored Procedure

Answered

Joseph Flesche

• September 07, 2021 21:31

I have a page that runs a Stored Procedure at the database level. If there is a concern with the Stored Procedure (either based on the data passed or based on some conditions within the logic of the Stored Procedure), I would like to report an error to the end user.

I have tried RAISERROR with the following code.

RAISERROR ('Record was not updated. Please contact Joe for assistance.', -- Message text.
16, -- Severity.
1 -- State.
);

But the message returned is a bit tough to read.

I looked through the online Syniti manual but was not able to find any details around this.

Is this the proper way for error handling from the database? Is there another preferred method?

I considered using Validation Rules, but I am passing a value from a parent page to the page I am working on.

0

• Best answer

  

  Tyler Warden

  • September 08, 2021 13:57

  You could use a Validation Stored Procedure as opposed to a Validation View.  I think the approach you used is a good one but, as you said, the control you have over error messages is limited.  

  Your approach for error handling form the database is what I suggest you use - yes - but if you can use validation views/procedures to catch the errors before hand I think you will give a better UX

   

  0
• 

  Joseph Flesche

  • September 08, 2021 14:13

  You could use a Validation Stored Procedure as opposed to a Validation View.

  Good point. And this logic would be generic in nature, so I could have a generic stored procedure written to pass the parent page variable / value. In order to limit the number of Stored Procedures, I believe that I need to remove the strict naming convention (problem is that this is a shared WebApp).

  Your approach for error handling form the database is what I suggest you use - yes - but if you can use validation views/procedures to catch the errors before hand I think you will give a better UX

  Agreed and makes sense. Thank you for the feedback.

  0

Please sign in to leave a comment.