MySQL Forums :: Stored Procedures :: Error Code: 1320 No RETURN found in FUNCTION


Advanced Search

Error Code: 1320 No RETURN found in FUNCTION
Posted by: Scott Dornseif ()
Date: April 18, 2017 02:28PM

After searching all other posts with this error I still can not find my error.

MySQL5 Getting the No Return error on a function copied from an other server where there is no issue.

To simplify debugging, I tried creating the simple function below:
This gives me the smae error...

DELIMITER $$

CREATE
/*[DEFINER = { user | CURRENT_USER }]*/
FUNCTION `kccvbcontent`.`bob`()
RETURNS VARCHAR(50) CHARSET utf8

NOT DETERMINISTIC
NO SQL
SET GLOBAL log_bin_trust_function_creators = 1;

BEGIN
DECLARE bob_out VARCHAR(50);
SET bob_out = 'bob it is';
RETURN bob_out;
END $$

DELIMITER ;

I do not know what I am missing...

Options: ReplyQuote


Subject Views Written By Posted
Error Code: 1320 No RETURN found in FUNCTION 72 Scott Dornseif 04/18/2017 02:28PM
Re: Error Code: 1320 No RETURN found in FUNCTION 18 Peter Brawley 04/18/2017 03:04PM


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.