SQLLDR in Oracle 9i

Hi All,

I see that in 9i SQLLDR has some significant enchancements. I'm looking at the options for Input Row Object Subtypes.

However, even after copying the control file from the manual, I receive an error when I invoke SQLLDR.

Here is my control file I copied from the manual:

OPTIONS (ERRORS=500, SILENT=(FEEDBACK))
LOAD DATA
INFILE 'input.txt'
BADFILE 'input.bad'
DISCARDFILE 'input.dsc'
APPEND
INTO TABLE persons
REPLACE
WHEN typid = 'P' TREAT AS person_t
FIELDS TERMINATED BY ","
(typid FILLER POSITION(1) CHAR,

  name            CHAR,
  age             CHAR)

INTO TABLE persons
REPLACE
WHEN typid = 'E' TREAT AS employee_t
FIELDS TERMINATED BY ","
(typid FILLER POSITION(1) CHAR,

  name            CHAR,
  age             CHAR,
  empid           CHAR,
  deptno          CHAR,
  dept            CHAR)

INTO TABLE persons
REPLACE
WHEN typid = 'S' TREAT AS student_t
FIELDS TERMINATED BY ","
(typid FILLER POSITION(1) CHAR,

  name            CHAR,
  age             CHAR,
  stdid           CHAR,
  major           CHAR)

sqlldr control=input.ctl, LOG=input.log USERID=user/password

SQL*Loader-350: Syntax error at line 9.
Expecting "(", found "TREAT".
WHEN typid = 'P' TREAT AS person_t

Any suggestions? Received on Fri Oct 28 2005 - 16:37:28 CEST