Drop a Global Temporary Table using Classic ASP
- From: juan <juan.oceguera@xxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 11 Jun 2007 13:53:10 -0700
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
.
- Follow-Ups:
- Re: Drop a Global Temporary Table using Classic ASP
- From: Connor McDonald
- Re: Drop a Global Temporary Table using Classic ASP
- From: DA Morgan
- Re: Drop a Global Temporary Table using Classic ASP
- From: sybrandb
- Re: Drop a Global Temporary Table using Classic ASP
- Prev by Date: Re: What could be wrong with my DB if "drop table" hangs forever?
- Next by Date: UNIX System Database Startup Script
- Previous by thread: ORA-00932 and Select * from <table>, using nested table.
- Next by thread: Re: Drop a Global Temporary Table using Classic ASP
- Index(es):
Relevant Pages
|
