can we use multiple sql statements in a procedure?

[marist89]

No, that has to be in two EXECUTE IMMEDIATE statements.
execute immediate 'create table ' || table1 || ' (name varchar2(10))';
execute immediate 'create table ' || table2 || ' (name varchar2(10))';