Unanswered: How to call Function from a Stored Procedure?
I was hoping someone could tell me how you go about creating a stored procedure that calls a user function... everytime I create a function and then try to create a stored procedure that uses it, I get a syntax error.
CREATE FUNCTION FUNC1(str1 VARCHAR(100))
CREATE PROCEDURE PROC1(in str2 VARCHAR(100))
DECLARE x VARCHAR(100);