Re: HELP!!! ORA-600 [qctstc2o1]
- From: Paul Drake <discgolfdba@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 9 Jul 2004 08:13:38 -0700 (PDT)
--- "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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
