try fetch size 1 and array size 1
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Prakash" <venkatprakash_at_hotmail.com> wrote in message
news:78b3b5e2.0304140925.5275b004_at_posting.google.com...
> Hi
>
> I am trying to copy data from one table to another. Source has one
> Long Raw column. There are about million rows in source table. And I
> am using Oracle 8.1.5. Whenever I execute the copy command, I get the
> following error message: Can someone help me?
>
>
> SQL> set long 64000000
> SQL> set copycommit 1
> SQL> set arraysize 100
> SQL> COPY to test/test_at_testfix CREATE resume_bkup1 using select * from
> resume;
>
> Array fetch/bind size is 100. (arraysize is 100)
> Will commit after every array bind. (copycommit is 1)
> Maximum long size is 64000000. (long is 64000000)
>
> ERROR:
> ORA-01084: invalid argument in OCI call
>
> SQL>
>
> Thanks
>
> V Prakash
Received on Mon Apr 14 2003 - 20:49:04 CDT
