Dynstatic SQL... ....oracle

Here's Connor again...

Note that the following code has been "anonymised" to protect the guilty.

---

procedure P is
begin
  ...
  ...
  execute immediate 'drop  table T';
  execute immediate 'create table T as select * from ......';
  ...
  ...
  ...
  for i in ( select * from T ) loop
       ...
       ...
  end loop;
end;

Ah, a mix of dynamic and static references... Now how precisely did that compile? Nope, I'm not sure either.