ORA-01483

[mc59028]

Hi

I was wondering what I can do here.

Am I suppossed to increase the allowable lenth somewhere?

How?

SQL> COPY FROM barf/barf@ora.barf INSERT newsonlinedb.news USING select * from barf.barf where id in(1198784,1198678,1198782,1198771,1198770,1198773,1198781,1198758,1198776,1198772,1198778,1198779,1198783);

ERROR:
ORA-01483: invalid length for DATE or NUMBER bind variable

Action: Check your Oracle Operating System-specific documentaion for the maximum allowable length.

Many Thanks

MC!

 

[mc59028]

I have increased long by 'set long' to 2gb in sqlplus.

And now i get this error!

SQL> COPY FROM barf/barf@ora.barf INSERT barf.barf USING select * from barf.barf where id in (1198784,1198678,1198782,1198771,1198770,1198773,1198781,1198758,1198776,1198772,1198778,1198779,1198783);


Array fetch/bind size is 15. (arraysize is 15)
Will commit when done. (copycommit is 0)
Maximum long size is 2000000000. (long is 2000000000)

ERROR:
ORA-01084: invalid argument in OCI call

 

[karluk]

Have you tried executing the insert statement directly, rather than using a copy command? I would be interested in seeing whether you still get the ORA-01483 error.

I would tend not to take the ORA-01084 error too seriously. My guess is that 2000000000 is simply too large a value for long size. There must be some limit to the size of the output buffer.