SQL*Loader error when executing from shell script

Question

Getting error

LRM-00116: syntax error at ')' following ')'

while executing the below SQL*Loader statement from shell script. However, if I execute the same single statement as command line argument, then it is working fine.

Can you please help to understand this error?

sqlldr USR/PWD@HOST control=<(echo "LOAD DATA INFILE input.csv BADFILE input.csv_bad DISCARDFILE input.csv_dsc INSERT INTO table TEMP_INPUT_TBL FIELDS TERMINATED BY ',' TRAILING NULLCOLS (CBPID,SAM_KEY,HHID)")

I think it related to escape character.

Amir
– Amir

2018-09-25 17:11:40 +00:00
Commented Sep 25, 2018 at 17:11 — Amir
– Amir, Commented Sep 25, 2018 at 17:11

Littlefoot · Accepted Answer · 2018-09-25 19:42:21Z

1

Why do you do it that way? Normally, you'd create a control file (let's call it load.ctl) and use it while running SQL*Loader, e.g.

LOAD DATA 
INFILE input.csv 
BADFILE input.csv_bad 
DISCARDFILE input.csv_dsc 

INSERT INTO table TEMP_INPUT_TBL 
FIELDS TERMINATED BY ',' 
TRAILING NULLCOLS 
(CBPID,SAM_KEY,HHID)

and then

sqlldr USR/PWD@HOST control=load.ctl

answered Sep 25, 2018 at 19:42

Littlefoot

144k15 gold badges41 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL*Loader error when executing from shell script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related