MySQL Forums
Forum List  »  Stored Procedures

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
5669
April 18, 2017 02:28PM


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.