OraFAQ Forum: SQL & PL/SQL » COPY command in SQL giving some error

Home » SQL & PL/SQL » SQL & PL/SQL » COPY command in SQL giving some error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

COPY command in SQL giving some error [message #19327]

Tue, 12 March 2002 03:15

Aswin Kumar
Messages: 4
Registered: January 2002

Junior Member

I am trying to use COPY sql command to insert some data from a seperate local database and I am getting the following error, Can anybody help me out with this:
-----------------------------------------------------
copy from lcs/lcs@nextlinx to lcs/lcs@lcs_test -
replace lcs_hts -
using select * from lcs_hts;

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

ERROR:
ORA-01458: invalid length inside variable character string
-------------------------------------------

Report message to a moderator

Re: COPY command in SQL giving some error [message #19341 is a reply to message #19327]

Tue, 12 March 2002 10:49

andrew again
Messages: 2577
Registered: March 2000

Senior Member

there are restrictions with datatypres on the copy command. Have you checked the documentation on those - I don't know them offhand. I think LONG is one of the ones not supported.

Report message to a moderator

Re: COPY command in SQL giving some error [message #19348 is a reply to message #19341]

Tue, 12 March 2002 19:25

Aswin Kumar
Messages: 4
Registered: January 2002

Junior Member

Thanks,
I checked the docs, COPY supports LONG but not LONG RAW,
But I have no LONG datatypes in any of my tables, I guess there is some other problem. Still I am getting the same error.

Report message to a moderator