You can certainly _use_ a temporary memory table from inside a stored function but you should create the table earlier before calling the stored function and you may want to truncate the table at the start/end of the function.