| SQL*Loader and .bat files [message #169008] |
Mon, 24 April 2006 11:31  |
cjsx
Messages: 10
Registered: March 2006
|
Junior Member |
|
|
I am processing a control file via SQL*Loader. When SQL*Loader is done then I want to continue back to my batch file and process the next command (which is a SQL*Plus command) but the next command is never processed? Is there a command I should put in the SQL*Loader control file?
Here is my batch file (the last line needs to run but is not):
@ECHO OFF
set oracle_home=c:\oracle\10gclient
SQLPLUS /NOLOG @\\scripts\EOB\e_tables.sql
SQLLDR CONTROL = "\\scripts\EOB\e.ctl", LOG="\\scripts\EOB\e.log", BAD = "\\scripts\EOB\e.bad", DATA= "\\scripts\EOB\e_62", USERID=id/pw@deves
SQLPLUS /NOLOG @\\scripts\EOB\e_run.sql
--
Thanks,
cj
|
|
|
|
| Re: SQL*Loader and .bat files [message #169020 is a reply to message #169008] |
Mon, 24 April 2006 13:31  |
markmal
Messages: 113
Registered: April 2006
Location: Toronto, Canada
|
Senior Member |
|
|
That can happen for example if you have SQLLDR.BAT or .CMD file.
Try
SQLLDR.EXE CONTROL = "\...
By the way, does loader work and finish when you run it directly from command line?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
