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 ?
150
July 19, 2018 02:12AM


Sorry, you can't reply to this topic. It has been closed.

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.