Oracle Error...Any Ideas

From: Bhavesh Gosar <gosar_at_bhavesh.ebay.sun.com>
Date: 1998/09/01
Message-ID: <6shm68$411$2_at_ebaynews1.Ebay.Sun.COM>#1/1


[Quoted] We are using the SQL*Plus Copy command to get data from another Oracle Db. and we get the foll. error message:



Array fetch/bind size is 100. (arraysize is 100) Will commit after every 200 array binds. (copycommit is 200) Maximum long size is 80. (long is 80)

ERROR:
ORA-00604: error occurred at recursive SQL level 1 ORA-01013: user requested cancel of current operation



We are using SQL*Plus: Release 3.3.3.0.0

             Oracle7 Server Release 7.3.3.0.0

There is no trace file generated nor anything is recorded in the alert log.

One interesting thing to note is The Download terminates after it has downloaded data to the nearest 100 of the total # of records.

Source Data Records on 8/31 was : 488912 Records downloaded before erroring out : 488900

Source Data Records on 9/1 was : 488951
Records downloaded before erroring out : 489100

Any Ideas..

Please reply to me directly...as i am not a frequent visitor to these newsgroups.

Thanks,
Bg Received on Tue Sep 01 1998 - 00:00:00 CEST

Original text of this message