Drop a Global Temporary Table using Classic ASP

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
Not sure about Oracle. But in SQL Server you cannot delete a global
temporary table even if one connection references it. So I would check if
there are connections that access it, and kill those. Or wait until those
connections are completed then delete it.
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"juan.oceguera@.nav-international.com" 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
>