I am trying to call a stored procedure in a user defined function.
Code:
CREATE FUNCTION test ()
RETURNS DECIMAL (15,4)
LANGUAGE SQL
READ SQL DATA
EXTERNAL ACTION
F1: BEGIN
DECLARE VAR1 DECIMAL(15,4);
DECLARE VAR2 VARCHAR(256);
call test1('C','F',545,VAR1,VAR2);
RETURN var1;