MySQL Forums
Forum List  »  Stored Procedures

Error Code: 1172. Result consisted of more than one row INSIDE A FUNCTION
Posted by: Nestor Pedraza
Date: March 05, 2022 07:09PM

Hello everybody thanks you in advance. I’m getting this error message when I run a user defined function .
The function just read from a table the EURO exchange value for a certain date. There is a unique result for each date, but keep given me the message .
Here is the code

CREATE DEFINER=`myNestor`@`%` FUNCTION `EURO`(FEC DATE ) RETURNS decimal(11,2)
BEGIN
SET @TODAY=FEC;
SELECT EURO FROM DATA.IYM WHERE DOER=@HOY INTO @RESULT ;
RETURN @RESULT ;
END

Options: ReplyQuote


Subject
Views
Written By
Posted
Error Code: 1172. Result consisted of more than one row INSIDE A FUNCTION
1176
March 05, 2022 07:09PM


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.