Expecting "," or ")", found "nvarchar2"
-1
votes
1
answer
154
views
Here is my SQL*Loader: Release 11.2.0.2.0 - Production on Fri Nov 10 00:39:56 2023
OS=UBUNTU 20
I am trying to load data from csv file with the help of following code:
OPTIONS (SKIP=1)
LOAD DATA
INFILE '/home/oracle/airports.csv'
INTO TABLE airportDemoData
fields terminated by ',' optionally enclosed by '"'
(
country nvarchar2(48),
country_code varchar2(2),
city nvarchar2(48),
city_code varchar2(3),
airport nvarchar2(84),
airport_code varchar2(3)
)
Here is sample of my csv file:
Here is my sqlldr command running in oracle user:
Here is the error that I am facing:
SQL*Loader: Release 11.2.0.2.0 - Production on Fri Nov 10 00:39:56 2023 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. SQL*Loader-350: Syntax error at line 7. Expecting "," or ")", found "nvarchar2". country nvarchar2(48), ^ Please help me to point out where I am making mistake Best Regards

sqlldr login/pass control=airport.ctl LOG=airport.log
Here is the error that I am facing:
SQL*Loader: Release 11.2.0.2.0 - Production on Fri Nov 10 00:39:56 2023 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. SQL*Loader-350: Syntax error at line 7. Expecting "," or ")", found "nvarchar2". country nvarchar2(48), ^ Please help me to point out where I am making mistake Best Regards
Asked by Java_Beginner
(1 rep)
Nov 9, 2023, 09:25 PM
Last activity: Nov 9, 2023, 09:57 PM
Last activity: Nov 9, 2023, 09:57 PM