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 -> Re: Drop a Global Temporary Table using Classic ASP

Re: Drop a Global Temporary Table using Classic ASP

From: <sybrandb_at_hccnet.nl>
Date: Tue, 12 Jun 2007 00:38:40 +0200
Message-ID: <1mjr63h3jrk4ral8k5m993kfun6n7neag3@4ax.com>


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

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
Received on Mon Jun 11 2007 - 17:38:40 CDT

Original text of this message

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