SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL LOADER DATA INSERT ISSUES

424258Jul 8 2009 — edited Jul 8 2009

I tried inserting data into an empty table in my database but got the following error:

SQL*Loader: Release 11.1.0.6.0 - Production on Tue Jul 7 22:01:35 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

SQL*Loader-350: Syntax error at line 7.
Expecting "," or ")", found "VARCHAR2".
countryname VARCHAR2(25),
^

What is wrong what this please? Find below the contents of .CTL and .DAT files.

Content of load_country.CTL
LOAD DATA
infile '/D:/Data/Load/load_country.dat'
INTO TABLE ASSET.COUNTRY
INSERT
FIELDS TERMINATED BY ';'
(countrycode,
countryname VARCHAR2(25),
population NUMBER(10))

The content of the load_country.DAT file:
BEN;Benin;8791832
BFA;Burkina Faso;15746232
CPV;Cape Verde;503000

Thank you.

Ofonime Essien.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 5 2009

Added on Jul 8 2009

6 comments

3,973 views