Procedure Name as Variable

Help Procedural SQL
1

I am migrating code from SQL Server to MemSQL. SQL Server allows me to put the name of a stored procedure into a variable, then call the stored procedure using the variable. Using MemSQL syntax, it would be like this:

DECLARE proc_name VARCHAR(100);
SELECT name_of_sp INTO proc_name FROM some_table;
CALL procname;

Is it possible to do this in MemSQL or do I need to use dynamic SQL?

2

I should add that I have tried the syntax that I posted and it does not work, so my question is really whether I just need to adjust my syntax a little or whether dynamic SQL is the only way.

3

You could use a UDF or UTF function if you want to use within a SQL query.