ORA-01401 problem with tables in two different instances

Hi,

I'm writing a Pro C program that transfers data from one table into another table in a different instance using a dblink in Oracle 8i. Encountered the error: 'ORA-01401 inserted value too large for column' when trying to insert a particular field. This field is declared as a varchar(140) in the temporary structure that its being stored after fetching.
In both tables, the particular cloumn sizes are also defined as varchar2(140).
The field is null terminated after being fetched, and printf shows that length of the field is only 27 chars. There shouldn't be any errors in the dblink because when the above field is commented out, the insert statement worked fine with the other fields being uploaded.

appreciate if anybody could shed some light, thanks. zack Received on Mon Aug 20 2001 - 00:56:13 CDT