Query Has No Destination For Result Data

Well, this happens when we try to create a function that does not return a selected result set as it has to return the set.

Reason for the error you're getting is because there is no return statement in between your BEGIN and END. After all, the return statement sends or displays the output.