Re: regarding Temp. Table

From: DriftWood <drift_wood_at_my-deja.com>
Date: Tue, 09 Jan 2001 16:42:41 GMT
Message-ID: <93ff20$tfc$1@nnrp1.deja.com>

from the docs:
http://technet.oracle.com/docs/products/oracle8i/doc_index.htm

use the DBMS_SQL.
c number;
n number;
BEGIN
c:= dbms_sql.open_cursor;
dbms_sql.parse(c, 'create TEMPORARY table BLAH;', dbms_sql.native); n := dbms_sql.execute(c);
dbms_sql.close_cursor(c);
END;
dbms_sql();

use the GLOBAL TEMPORARY to give it global (vs. session) scope.

--
-cheers

  DW

---

"It is a kind of good deed to say well; and yet words are not deeds.   -William Shakespeare"

Sent via Deja.com
http://www.deja.com/ Received on Tue Jan 09 2001 - 10:42:41 CST