MySQL Forums
Forum List  »  UDF

Re: How to return errors from UDF ?
Posted by: Mathieu Dubois
Date: July 19, 2018 02:12AM

Hello,

You understood my problem well: how to tell the user that something is wrong in the UDF.

I'm a bit nervous about your solution because it could put garbage in our DB... So I will stick to the idea of returning NULL because we usually have non-NULL constraints so at least the query will be interrupted. However if NULL is a valid return value for the UDF, there is no way to report the error.

For you question about the component architecture, I have no idea what you're talking about but it sounds interesting.

Cheers,
Mathieu

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to return errors from UDF ?
66
July 19, 2018 02:12AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.