Oracle SQL*Loader control file problem

From: <bpleshek1_at_my-deja.com>
Date: Fri, 15 Dec 2000 21:13:09 GMT
Message-ID: <91e1gu$jc7$1@nnrp1.deja.com>

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/ Received on Fri Dec 15 2000 - 15:13:09 CST