Re: Insert fails ORA-24345

From the SQL*Plus on our PC we can execute a SELECT against the remote table, thus demonstrating that the connection is ok. As I said, an INSERT fails. But executing the same INSERT from any other client on any other PC (tried several), using the same account, succeeds. This indicates that the problem lies with our PC, except that I have re-installed Oracle (now using 8.1.6, as used on every PC at the clients site, using their 8.1.6 CD) and the INSERT still fails. However INSERT from our PC to any other table (on the same server or anywhere else) succeeds.

So some of the evidence points to the problem lying with our PC, but everything we've done with it points to the problem being with thier table.

That error code shouldn't, I think, even come from an INSERT but from a SELECT. Very confusing. Their dba's are now looking into it as the problem looks like being on their side, our site acceptance tests still pass (the original table design we agreed to export to still works).

Tim Received on Mon Sep 20 2004 - 07:42:45 CDT