Database Software

Hi all,

I ran into a problem when I try to load a control file. I need to supply SQL folder which will have below files.

1. build.sql
2. Control.ctl
3. MyLDR.ldr

The build.sql file contains below statement.

HOST sqlldr &&USER/&&PASSWRD@&&DB Control='Control.ctl'

The control file would have CLOB values to load into a table.

Control file looks like this

load data
infile *
truncate
into table MYTABLE
fields terminated by '|'
(

)
begindata
*4|MyLDR.ldr*

All required files (MyLDR.ldr, Control.ctl and build.sql) are in same folder (C:\SQL). When I run sqlplus username/password@db @build.sql, I got below error.

SQL*Loader: Release 11.1.0.6.0

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

SQL*Loader-500: Unable to open file (Control.ctl)
SQL*Loader-553: file not found
SQL*Loader-509: System error: The system cannot find the file specified.

I can load ldr file using slqldr with out creating any sql script. But, I need to folow as I explained.

I have tried by giving full path of the Control.ctl in build.sql as mentioned below.

HOST sqlldr &&USER/&&PASSWRD@&&DB Control='C:\Control.ctl'

Again I got another error saying MyLDR.ldr file not found.

If I give full path everywhere, I could execute it successfully. But, I need to generalize it. I could not resolve the problem.
Please suggest me.