I created external table as below
CREATE TABLE APPS.ABC_JSON_EXT
(
JSON_DOC CLOB
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY INCOMINGHR
ACCESS PARAMETERS
( RECORDS DELIMITED BY newline
FIELDS
(json_doc CHAR(5000000000))
)
LOCATION (INCOMING:'adp.json')
)
REJECT LIMIT UNLIMITED;
when i execute this i am facing below error
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01006: error signalled during parse of access parameters
KUP-04029: numeric field overflowed
Can anyone suggest regarding this