i'm on oracle 19 i have an external table i read a csv file where a data is a char(2) like '04' in a column named YEAR i need to load this data trasnform in a YEAR on 4 char like 2004 if i implement in the ext table create definition the column like
CREATE TABLE "AAA"."EXT_TAB0200"
(
"FIELD" VARCHAR2(4 BYTE)
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY "UTLFILE1_PATH"
ACCESS PARAMETERS
(
RECORDS DELIMITED BY NEWLINE
CHARACTERSET WE8MSWIN1252
BADFILE UTLFILE1_PATH:'TAB02.BAD'
NODISCARDFILE
LOGFILE UTLFILE1_PATH:'TAB02.LOG'
FIELDS LRTRIM (
FIELD POSITION(00001:00002) CHAR DATE_FORMAT DATE MASK "RRRR"
) )
LOCATION
( 'TAB02'
)
)
REJECT LIMIT 0 ;
i have an ORA-29913: error in executing ODCIEXTTABLEFETCH callout
how can i transform the data read, the char(2) character like 04 in an YEAR in 4 char format like 2004?