Error Code: 1320 No RETURN found in FUNCTION
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...
Subject
Views
Written By
Posted
Error Code: 1320 No RETURN found in FUNCTION
5442
April 18, 2017 02:28PM
997
April 18, 2017 03:04PM
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.