Re: Oracle SQL*Loader control file problem

On Saturday, December 16, 2000 2:50:13 AM UTC+5:30, bple..._at_my-deja.com wrote:
> I'm trying to load an Oracle table from a text file. I'm getting
> errors in my control file. I'm trying to concatenate some fields in
> the input text file to form one field in Oracle. Below is my control
> file and the error message I get. I appreciate any help.
>
> Thanks,
>
> Brian Pleshek
> brian.pleshek_at_lmberry.com
>
> ***Control file:
>
> LOAD DATA
> INTO TABLE LISTLOAD
> (
> PHONE POSITION(14:23) CHAR,
> ACCOUNT_NO POSITION(14:23) || POSITION(11:13)
> CHAR,
> STATE POSITION(40:41) CHAR,
> ADDRESS_LINE_1 POSITION(43:82) CHAR,
> ADDRESS_LINE_2 POSITION(83:108) CHAR,
> ADDRESS_LINE_3 POSITION(123:162) CHAR,
> ADDRESS_LINE_4 POSITION(163:202) CHAR,
> ADDRESS_LINE_5 POSITION(203:242) CHAR,
> LATA_CODE POSITION(243:245) CHAR,
> VERT_SVCS_SPEND POSITION(254:264) CHAR
> )
>
> ***ERROR MESSAGE:
>
>
> SQL*Loader-350: Syntax error at line 5.
> Illegal combination of non-alphanumeric characters
> ACCOUNT_NO POSITION(14:23) || POSITION(11:13)
>
> ***Another Try:
>
> ACCOUNT_NO CONCATENATE(POSITION(11:13),:PHONE)
> CHAR,
>
> ***ERROR MESSAGE:
>
> SQL*Loader-350: Syntax error at line 5.
> Expecting valid column specification, "," or ")", found keyword
> concatenate.
> ACCOUNT_NO CONCATENATE(POSITION(11:13),:PHONE)
> ^
>
> Again, I appreciate any help.
>
>
> Sent via Deja.com
> http://www.deja.com/

Can Anyone help me in my control file , I am getting an error :

SQL*Loader-350: Syntax error at line 18. Expecting valid column specification, "," or ")", found "("

My CTL file is :

LOAD DATA
INFILE 'DSS_EMPLOYEE.DAT'
INTO TABLE EMPLOYEE
(
INPUT_DATE (1:2),
DESCRIPTION (3,4)
)

Thanks
Himanshu Received on Thu Apr 03 2014 - 11:15:12 CEST