topic Re: Regarding Sqlldr in Operating System - Linux

Regarding Sqlldr

ancys — Mon, 31 Jul 2006 07:17:41 GMT

Posts: 3

Regarding Sqlldr
« on: Today at 05:49:45 am » Quote Modify Remove

--------------------------------------------------------------------------------
hi all

I need to read the text file and update into database

Text file samp.txt
1#arun
2#aparna

Table -Employee
Emp empname
Script
#!bin/sh
sqlldr username/password@database control=control.ctl

control.cl
load data infile 'sample.txt' into table employee fields terminated bu '#' trailing nullcols(emp.empname)

The above statements get executed
but i dont want control file to be as separate file

I want it to be part of the script
#!bin/sh
sqlldr username/password@database control=load data infile 'sample.txt' into table employee fields terminated bu '#' trailing nullcols(emp.empname)

I shows an error unexpected end of file
How to solve this

Re: Regarding Sqlldr

g33k — Mon, 31 Jul 2006 07:28:42 GMT

try to add one [enter](I mean new line before EOF). Some say there's unexpected EOF when you have

code
code
codeEOF

but
code
code
code
EOF

is OK.

Re: Regarding Sqlldr

ancys — Mon, 31 Jul 2006 08:19:38 GMT

after includng EOF after the qlldr code also it shows be some error

How to make a control file to be a part of the script

Re: Regarding Sqlldr

g33k — Mon, 31 Jul 2006 09:32:58 GMT

well can you post here what is the error message you get.

Can you of course post actual script you are trying to debug?