Wednesday, September 30, 2015

SQL Loader: Field in data file exceeds maximum length


Field in data file exceeds maximum length

The default length of datatype CHAR is 255 in SQLLDR.

Instead of the following
-----------------
COL1 CHAR,
COL2 CHAR,
-----------------

Please change into
-----------------
COL1 CHAR(1000) NULLIF COL1=BLANKS,
COL2 CHAR(4000) NULLIF COL2=BLANKS,
-----------------


1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete