Is there a method, at compile time, to have the stored procedure resolve a volatile table that is not created within the stored procedure?
Try to include "SQL SECURITY INVOKER" at the beginning of the SP. SQL Securty invoker will give a warning during compilation for any dynamic sqls that are present in db.
Something like this...
Replace Procedure SPName (Param1, Param2... Param n)
SQL SECURITY INVOKER
Declare var1 datatype;
Declare var2 datatype;
Hope it helps.