Re: passing a table as a INPUT parameter to a stored procedure

[Peter Brawley]

> mysql> call dyn_sql(SOURCE, temp_table,123,sjdladj);

source, temp_table and sjdladj are unquoted strings, which tells MySQL to treat them as identifiers, which it can't since they have no context. If you mean to send them in as string constants, you need to quote them.

After executig a repared stmt, you need to call Drop Prepare.