Hi ,
I am trying to load a file through sql loader into an ordinary oracle table . My requirement is as follows
-Load the whole line into the input_values column of the ordinary table .
-When I load the data , i am separating the data with semicolon at specific positions
But I am facing the below error, when I execute the sql loader
SQL*Loader-350: Syntax error at line 10.
Token longer than max allowable length of 258 chars
;'||rtrim(substr(:input_values,431,449))||';'||rtrim(substr(:input_val
My control file
LOAD DATA
CHARACTERSET WE8ISO8859P1
APPEND
INTO TABLE ATG_RMS_INTEGRATION_STUBS_STG
TRAILING NULLCOLS
(
stub_type constant "UDA",
input_values position(1:498)
"rtrim(substr(:input_values,1,30))||';'||
rtrim(substr(:input_values,31,150))||';'||
rtrim(substr(:input_values,151,175))||';'||
rtrim(substr(:input_values,176,180))||';'||
rtrim(substr(:input_values,181,430))||';'||
rtrim(substr(:input_values,431,449))||';'||
rtrim(substr(:input_values,450,468))||';'||
rtrim(substr(:input_values,469,498))"
)
Please help me on my approach / sql loader error
Thanks,
SH