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

--- "Smith, Ron L." <rlsmith@xxxxxxx> 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.

Pd

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: