Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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 Received on Mon Jun 11 2007 - 15:53:10 CDT
![]() |
![]() |