Re: Dynamic SQL in Stored procudures

[Per-Erik Martin]

There's no "EXEC" of a string currently (there might be in the future though).
But it's possible to work around with prepared statements:

delimiter //;
create procedure tst()
begin
prepare stmp from 'INSERT INTO LOGG SELECT PFILE_Filename FROM PFILE_FILE';
execute stmp;
deallocate prepare stmp;
end//
delimiter ;//

But beware, prepared statement handles are session global, so it must be used with some care.