I currently have multiple dynamic queries created and everything is working great except in one of my stored procedures. I keep receiving the error "...SQL statement empty or blank...During precompiling, the SQL statement referred to has no text between the EXEC SQL and the ending delimiter..."
This doesn't make sense because I'm not doing anything different than my other files. I've even tried to copy/paste a statement from a different procedure, which has ran without a problem, and I receive the same error. Any ideas?
DECLARE STMT varchar(1000);
SET STMT = 'UPDATE '||TableParm||' SET x=?...';
PREPARE s1 FOR STMT;
EXECUTE s1 USING PARM1;