SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

data type max length issue

user626688Feb 14 2011 — edited Feb 14 2011

Hi Guys,

I am loading a huge file using SQL Loader into an oracle table. THis table has only one Column of VARCHAR2(4000); THe incoming values have all kinds of characters in it. Some records are rejected by the loader because it exceeds the max length allowed for this column. How can i process those records as well whose max length exceeds 4000 characters?. I changed the varchar2(4000) to clob and incresed the sql loader delcaration to char(8000) but it error out showing the following error.

SQL*Loader-350: Syntax error at line 7.
Illegal combination of non-alphanumeric characters

Is there any work around to load those records as well that has more than 4000 characters?

Please help.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 14 2011

Added on Feb 14 2011

4 comments

145 views