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

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Fri, 9 Jul 2004 10:51:58 -0400
Message-ID: <564DE4477544D411AD2C00508BDF0B6A2133DDE6@usahm018.exmi01.exch.eds.com>

Ron, how about replacing the SQL statement with a pl/sql block that selects the data into pl/sql variables then performs the insert as a separate statement since it appears from your post you are doing a single row insert this should not affect performance.

HTH -- Mark D Powell --

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Smith, Ron L. Sent: Friday, July 09, 2004 10:35 AM
To: oracle-l_at_freelists.org
Subject: HELP!!! ORA-600 [qctstc2o1]

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.

Any ideas?

Thanks!
Ron

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


-----------------------------------------------------------------

----------------------------------------------------------------

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 - 09:49:34 CDT