Hi all

I want to run a dinamic sql statement in procedure:

CREATE PROCEDURE test()
BEGIN
declare qry varchar(200);
qry = 'SELECT emp_lname, emp_fname FROM employee';
execute immediate qry;
END

Assume that there are more then one records in employee table.
When I call this proc, system raise an error:
"SELECT returns more than one row"

How can I fix this error?

Thanks in advance
Thi Nguyen