为什么使用EXECUTE IMMEDIATE运行此查询会导致它失败？

I am writing a PL/SQL procedure that needs to to dynamically generate some queries, one of which involves creating a temporary table using results from a query taken as a parameter.I am writing a PL/SQL procedure that needs to t