DROP PACKAGE foopack;

CREATE PACKAGE foopack
IS
  foovar integer;
  PROCEDURE fooproc;
END;

CREATE PACKAGE BODY foopack
IS

  PROCEDURE fooproc IS
  BEGIN
    CREATE TEMPORARY TABLE footable2 (id integer);
  END;
END;

exec foopack.fooproc;
