Re: ORA-01461 error with conversion from SqlSrv to oracle

Jan van Veldhuizen (jan_at_van-veldhuizen.nl) wrote:
: I worte a conversion program which moves all data from SqlSrv to Oracle,
: using the OracleClient and SqlClient classes of .Net.

: Now when a column has 2001 characters or more I get this error. I've read a
: lot of it, but I do not fully understand what is wrong, and more important,
: how it can be solved.

I have read and assume to be true, that Oracle 8 & 9, maximum size of CHAR is 2000 characters

Therefore I assume the data is being copied to a CHAR column and therefore a 2001 length data will fail.

You could define the column as VARCHAR2 to get twice as long (max 4000 in oracle 8 & 9)

I have no idea what doing that would look like in visual basic.

--

This space not for rent.