Re: Insert fails ORA-24345

Tim Bedford wrote:

> 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

Now using 8.1.6 answers at least one problem. You are working on an unsupported Neolithic version of the database that, even when it was the state of the art, was not one of Oracle's proudest moments.

At a minimum upgrade to 9.2.0.5.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)