Re: ORA-01002: fetch out of sequence

From: blinky <blinky_at_nospam.com>
Date: 2000/07/31
Message-ID: <sobbnfn99ft135@corp.supernews.com>#1/1

"Tom Best" <tabest_at_bellatlantic.dontspamme.net> wrote in message news:rUZg5.2158$oA6.138197_at_typhoon2.ba-dsg.net...
> Blinky:
>
> This doesn't really make sense to me, but it's worth a try to see if it
> fixes it...
>
> In SQL*Plus, set ARRAYSIZE to 100 and COPYCOMMIT to 100.
>

I tried it, but no luck...
Why did you suggest that ?

---

 Here is the copy from command I'm using  (with schema, tns, and table name changed) I do this in a standalone, just run sql*plus window...

---

truncate table mytable
set arraysize 100
set copycommit 100
copy from myschema_at_mytns to myschema2_at_mytns insert mytable   using select * from mytable

Error in SELECT statement: ORA-01002: fetch out of sequence

*** Received on Mon Jul 31 2000 - 00:00:00 CDT