/--给个例子，试一下：

create table SSS
(
  ID     NUMBER,
  VALUE1 NUMBER
)

insert into sss values(1,2);

CREATE OR REPLACE PROCEDURE BBBB(PO_RESULT OUT SYS_REFCURSOR) IS
BEGIN
  execute immediate 'CREATE GLOBAL TEMPORARY TABLE AAA (NUM VARCHAR2(10),QTY INTEGER) ON  COMMIT  DELETE ROWS ';

  execute immediate 'insert into AAA SELECT * FROM sss';

  OPEN PO_RESULT FOR 'select * from AAA';
END BBBB;

------解决方案--------------------
探讨

SQL code
CREATE OR REPLACE PROCEDURE BBBB(num OUT integer) IS
BEGIN
  execute immediate 'CREATE GLOBAL TEMPORARY TABLE AAA (NUM VARCHAR2(10),QTY INTEGER) ON  COMMIT  DELETE ROWS ';

  execute immediate 'insert into AAA SELECT count(*) FROM sss';
  select a.num  into num from AAA a;
  commit;
END BBBB;

我是这样写的，不过是不对的。 
另外，这段代码要实现的功能我已经用别的方法实现了，…