oracle中temp与临时表,Oracle在存储过程中使用Temp表

我有一个使用临时表的查询，我想将其添加到存储过程。但是在编译时我得到＆＃34;错误(10,1)：PLS-00428：在这个SELECT语句中需要一个INTO子句＆＃34;

例如

WITH T1 as

(

SELECT ID, CREATED_DATE, LOOKUP_ID

FROM TEST1

),T2 as

(

SELECT ID, CREATED_DATE, LOOKUP_ID

FROM TEST2

)

SELECT * from T1

minus

SELECT * from T2

RESULTS

ID CREATED_D LOOKUP_ID

---------- --------- ----------

217322 11-DEC-16 1

作为存储过程添加：

create or replace PROCEDURE "TEST"

(

T IN OUT SYS_REFCURSOR

) AS

BEGIN

WITH T1 as

(

SELECT ID, CREATED_DATE, LOOKUP_ID

FROM TEST1

), T2 as

(

SELECT ID, CREATED_DATE, LOOKUP_ID

FROM TEST2

)

SELECT * from T1

minus

SELECT * from T2

end;

END;

错误(7,1)：PLS-00428：此SELECT语句中需要INTO子句