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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Smith, Ron L. Sent: Friday, July 09, 2004 10:35 AM To: oracle-l@xxxxxxxxxxxxx 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@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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------