reading sequence file

deva · Post by **deva** » Mon Jun 20, 2011 9:45 pm

Hi ,
I am reading a pipe delimited file which contain ID and description cols.

ID is char 4
description varchar2(30)

while reading a file it is erroring out as ID delimiter is missing.

If I changed to char to varchar , it is reading well.

Can any one help me why I am getting this issue.

ray.wurlod · Post by **ray.wurlod** » Mon Jun 20, 2011 10:49 pm

Because you have bad data - data that does not conform to your specified metadata. Either get the data changed so that they conform to the metadata or change the metadata so that they conform to the data.