Here is a copy of the SQlPLUS command used: SQL> set arraysize 1 SQL> set copycommit 1000 SQL> copy from kgel/vinotamu@nxtp - > insert nxtp.temp_mgh - > using - > select * from rrs$.temp_mgh
Array fetch/bind size is 1. (arraysize is 1) Will commit after every 1000 array binds. (copycommit is 1000) Maximum long size is 80. (long is 80) select * from rrs$.temp_mgh * Error in SELECT statement: ORA-01002: fetch out of sequence The table on the remote system is owned by RRS$ where the table I want to copy it to is owned by NXTP. The table structure is : SQL> describe temp_mgh Name Null? Type ----------------------------------------- -------- ---------------------------- CALC_SCHED_ID VARCHAR2(6) CALC_SCHED_TYPE VARCHAR2(15) SELECT_DATE DATE -----Original Message----- Sent: Friday, August 09, 2002 3:32 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Importance: High Kevin, This part just now caught my eye: > 3. When I try to use the plsql copy command (ultimately what I want to > do) , on machine B, I get an error stating that I am trying to Fetch out > of sequence. On machine A I get an unknow error that can not be > interpreted .... a long string of numbers as the error number. The COPY command is a SQLPLUS command, not PL/SQL. Can you post the actual PL./SQL code, or a simplified example if it is complex? Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
