Home » RDBMS Server » Server Utilities » SQL*Loader-350: Syntax error
SQL*Loader-350: Syntax error [message #144002] |
Mon, 24 October 2005 10:46 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sikyala
Messages: 33 Registered: May 2005
|
Member |
|
|
Here is my control file
LOAD DATA
INFILE 'c:\hsiac\hsiac1.txt'
INTO TABLE hsiac
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
(dummy char (4000),
ID VARCHAR2 (20),
PDF_NAME VARCHAR2 (255),
TITLE VARCHAR2 (2000),
SUBJECTKEYWORD VARCHAR2 (4000),
CATEGORY VARCHAR2 (70),
TYPE VARCHAR2 (70),
LOCATION VARCHAR2 (255),
AUTHOR VARCHAR2 (255),
PUBLISHER VARCHAR2 (255),
PUBLICATION_DATE DATE,
COPIES NUMBER,
CLASSIFICATION VARCHAR2 (50),
SECONDARY_DIST VARCHAR2 (4000),
ABSTRACT VARCHAR2 (4000),
COMMENTS VARCHAR2 (4000),
DATE_ENTERED DATE,
ENTERED_BY VARCHAR2 (50),
DISTRIBUTION_CODE VARCHAR2 (1),
PDF VARCHAR2 (255),
NUM_PAGES NUMBER,
SITE VARCHAR2 (255),
EMAIL_SUBMIT VARCHAR2 (1),
CORPORATE_AUTHOR VARCHAR2 (255),
CAT_IA VARCHAR2 (1),
CAT_INFOSEC VARCHAR2 (1),
CAT_INFRA VARCHAR2 (1),
CAT_IO VARCHAR2 (1),
CAT_MISC VARCHAR2 (1),
CAT_BIOMETRICS VARCHAR2 (1),
CAT_CND VARCHAR2 (1),
CAT_CNA VARCHAR2 (1),
CAT_MC VARCHAR2 (1),
CORPORATE_AUTHOR_ADDRESS VARCHAR2 (255),
CONTRACT_NUMBER VARCHAR2 (50),
GRANT_NUMBER VARCHAR2 (50),
STINT_SUBMIT VARCHAR2 (2),
NO_SUBMIT VARCHAR2 (2))
I am getting the following error:
SQL*Loader-350: Syntax error at line 9.
Expecting "," or ")", found "VARCHAR2".
ID VARCHAR2 (20),
^
I can't figure out how to fix this. Could someone please help me.
|
|
|
|
Goto Forum:
Current Time: Sat Aug 24 08:29:13 CDT 2024
|