I am trying to call a SP from a UDF. The procedure is independently executing file and I see some result. But, I do not see any result when I call it from a table UDF:

Code:
CREATE PROCEDURE repeat_stmt()
dynamic result sets 1
LANGUAGE SQL
BEGIN
  DECLARE c1 CURSOR with return FOR 
    SELECT empno,firstnme FROM employee;
  OPEN c1;
END


CREATE FUNCTION test ()
RETURNS table (emp_id VARCHAR(35), emp_name VARCHAR(35))
LANGUAGE SQL 
MODIFIES SQL DATA
BEGIN ATOMIC
declare i_emp_id varchar(35);
declare i_emp_name varchar(35);
call repeat_stmt();
return values (i_emp_id, i_emp_name);
END
Can some one pls tell what the problem is? Thank you very much.