SQL*Loader: Release 11.1.0.6.0 loading data in Database 11gR2 Linux 6 encounter error ORA-00907
I'm trying to load data in oracle table using SQL Loader utility 11gR1.
I have encountered error while uploading DAT file which has 2 rows however, first rows comprises into 2 lines and second rows falls in one line as illustrated below.
Record 1: Rejected - Error on table NI_TRANS_LD, column DLY_CREATION_DATE.
ORA-00907: missing right parenthesis
My DAT file:
==================================
Row No:1
FHNI201514400000124072014
3400005156240185230037MT1514401100140500000012305150000000534107840000000000000000000000000000000000053410AEDMEDIA ROTANA HOTEL DUBAI UAE7011O AH0802240515000515624018523003722
Row No:2
3410005156240251060029MT1514401101118800001212305150000001260007840000000000000000000000000000000000126000AEDETIHADAIR 60 72125844863 UAE3034R 240515000515624025106002922
==================================================================================================================
CONTROL FILE IS :
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
LOAD DATA TRUNCATE CONTINUEIF THIS (1:2) = "," INTO TABLE NI_TRANS_LD FIELDS TERMINATED BY '|' TRAILING NULLCOLS (DLY_FH_REC POSITION(1:2) ,DLY_FILE_ID POSITION(3:4),DLY_FILE_REFNUM POSITION (5:11) INTEGER EXTERNAL(7) ,DLY_FILE_TAPNUM POSITION(12:17) INTEGER EXTERNAL(6) ,DLY_CREATION_DATE POSITION(18:25) DATE "to_date(:DLY_CREATION_DATE),'dd/mm/yyyy')" ,