Re: HELP!!! ORA-600 [qctstc2o1]

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Fri, 9 Jul 2004 08:13:38 -0700 (PDT)
Message-ID: <20040709151338.59948.qmail@web20411.mail.yahoo.com>

"Smith, Ron L." <rlsmith_at_kmg.com> wrote:
> I am trying to use database links and synonyms to
> send data from 7.3.4
> to 8.1.7 to 9.2.

> Most of the processes are working. But I have one
> that gets an ORA-600
> [qctstc2o1] error every time I try it.

> I can hard code the insert and it's values in a SQL
> statement and the
> insert works. But if I select the values from
> tables to do the insert,
> like it would normally run, I get the ORA-600.

Ron,

(8.1.7.4.x) we had issues with db_links and cursor_sharing=FORCE.
setting cursor_sharing=EXACT aleviated the issue?

are there columns of data type LONG or LONG RAW involved?

check Note:216273.1 in metalink.
It also refers to several other notes that may be of interest.

hth.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Jul 09 2004 - 10:10:21 CDT