I have a stored procedure which is supposed to DROP 3 tables and then run 3 CREATE TABLE AS statements. Unfortunately that doesn't seem to work as only 1 DDL statement is allowed in a single stored procedure by default as I'm getting following error message:
Only an ET or null statement is legal after a DDL Statement.
Is there any other way that I'm missing how to place multiple DDL / CREATE TABLE AS statements in a single stored procedure or do I really have to create a single stored procedure for each DDL statement?
Any help appreciated!