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.
Please sign in to leave a comment.