在存储过程中需要动态sql创建表。
CREATE OR REPLACE PROCEDURE H2WE IS
v_sql varchar2(200);
BEGIN
v_sql:='CREATE GLOBAL TEMPORARY TABLE temp_table (id NUMBER,DAT VARCHAR2(100)) ON COMMIT DELETE ROWS';
execute immediate v_sql;
END ;