Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Drop a Global Temporary Table using Classic ASP

Drop a Global Temporary Table using Classic ASP

From: juan <juan.oceguera_at_nav-international.com>
Date: Mon, 11 Jun 2007 13:53:10 -0700
Message-ID: <1181595190.737827.100120@q69g2000hsb.googlegroups.com>


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 Received on Mon Jun 11 2007 - 15:53:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US