Re: Drop a Global Temporary Table using Classic ASP

juan wrote:

Good Afternoon,

I am hoping someone can help me out. I want to drop a global
temporary
table in classic asp after my recordset has completed printing out
it's rows.

I tried executing the following statement and I get the following
error:

Drop Table tmm_a03_gtt_YYYJCO3_0611154125

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC driver for Oracle][Oracle]ORA-14452: attempt to
create, alter or drop an index on temporary table already in use

FYI; We are using Oracle 10 g.

Thanks,

Juan

The way to clean up a GTT is:

"commit"


--
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald@xxxxxxxxx


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------
.

Relevant Pages