Re: Drop a Global Temporary Table using Classic ASP

On Mon, 11 Jun 2007 13:53:10 -0700, juan
<juan.oceguera@xxxxxxxxxxxxxxxxxxxxx> 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

You can't be bothered with looking up the error on tahiti? Because we
are not going to do this for you.

--
Sybrand Bakker
Senior Oracle DBA
.

Relevant Pages