Hi,

I have a scenario, where I have to load the data into External table. I have the file with 677KB size and record delimiter for file is '^row^'

When i tried to load the data , i am getting below error.

ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04020: found record longer than buffer size supported, 524288,

Can any one help me on this?

My code is like :

(TYPE ORACLE_LOADER
DEFAULT DIRECTORY DEFAULT_DIR
ACCESS PARAMETERS
(RECORDS DELIMITED BY ''rOw^''
skip 1
NOLOGFILE
NOBADFILE
NODISCARDFILE
FIELDS TERMINATED BY ''^''
OPTIONALLY ENCLOSED BY ''"''
MISSING FIELD VALUES ARE NULL
)Code {...}

(TYPE ORACLE_LOADER
DEFAULT DIRECTORY DEFAULT_DIR
ACCESS PARAMETERS
(RECORDS DELIMITED BY ''rOw^''
readsize 1048576
skip 1
NOLOGFILE 
NOBADFILE
NODISCARDFILE
FIELDS TERMINATED BY ''^''
OPTIONALLY ENCLOSED BY ''"'' 
MISSING FIELD VALUES ARE NULL
)