ORA-00903: invalid table name - COM+, ADO

From: Adam Boczek <adam.boczek_at_NO_SPAM_gft-solutions.de>
Date: Tue, 12 Mar 2002 11:04:53 +0100
Message-ID: <1015927457.589074@tux2.hamburg.gft.com>

Hi,

I have a strange problem :-| I have com+ component that updates about 300.000 records in simple table (Update MyTable Set MyTable.Status = x). Because x can have different values, this is not one query but loop that runs 300.000 times in com+ object. Everything works properly (transactions etc.) but sometimes comes error "ORA-00903: invalid table name". But it is all time the same sql-query (with one table)! Because of com+ specific I do not reuse connection to database (each sql-query started new connection and release it at end).

Thanx for help.

Oracle8i (8.1.7), ADO 2.6SP1, Win2k SRV SP2

Greets,
Adam

---

Adam Boczek
IT Consultant
GFT Solutions GmbH
adam.boczek_at_gft-solutions.de

---

Received on Tue Mar 12 2002 - 04:04:53 CST